Cisco Cisco Workload Automation 6.3 User Guide

Configuring the Oracle Applications Adapter

Defining an Oracle Applications Connection

 – Enter the parameter value.

The 

 section can contain the following parameters and default values:

 – Indicates whether the status of requests will be performed in batches (default = 

Y).  If set, 

 specifies the batch size (default=100).   When request statuses are 

checked in batches, fewer Database transactions are sent to the server.  Only after the batch size limit is 
reached, will a single Database transaction be initiated to get the status of all requests defined in the batch.  
Using this parameter may result in a slight delay in retrieving request statuses, if many requests are running.  If 

, then request statuses are not performed in batches.  This means a Database 

transaction is initiated for every request, resulting in more transactions being sent to the server.  With this option, 
there is no delay in waiting for the batch limit to be reached, however, it may result in slower performance as 
more Database transactions are initiated, 1 for every request.

 – Specifies the expiration time (in seconds) of any cached data.  The default is 600 

seconds or 10 minutes.

 – Enables debugging for the Oracle Applications adapter. Default value is 

.

 – Specifies the maximum number of connections opened to the Oracle Applications 

database. Default value is 5.

 – If 

, the health of the Standard Manager will be ignored when verifying 

the connection health.

 – If 

, the health of the Conflict Manager will be ignored 

when verifying the connection health.

Click 

 or 

 to display the 

 dialog.

Enter the name of the variable into the 

 field.

Enter the value for the variable in the 

 field.

Click 

. The variable record displays in the 

 tab.

Click 

.

Checking the Connection Status

Once you define an Oracle Applications connection, the newly defined connection is listed in the Connections pane as 
an agent. 

The Scheduler master continually monitors the health of the connection. If the Oracle Applications connection is not 
available to the master, the status light in front of the connection name is red, and the 

 status light at the 

bottom of the console is red (or yellow if other agents are connected to the master).