Cisco Cisco Workload Automation 6.3 User Guide

Configuring the Oracle Applications Adapter

Configuring Oracle for Scheduler

Configuring Interception Parameters

A parameter configuration table called 

 manages job interception in Oracle Applications. 

The following two parameters should be added to this table:



PROFILE_ACCESS – Specifies whether a user can configure the job interception queue filter criteria. The value is 
either 

 or 

.



MASTER_ALLOWED – Specifies which CWA Master is allowed to release jobs. The value is the host machine name. 

The Oracle Database Administrator should use the following SQL statements to populate the 

 

table:

Insert into sabdg_parameters(PARAMETER, VAL_BOOL) values (‘PROFILE_ACCESS’,’Y’)

Insert into sabdg_parameters(PARAMETER, VAL_STR) values (‘MASTER_ALLOWED’, ‘Host Name’)

Defining an Oracle Applications Agent List

You can assign jobs to run using OracleApps agent/adapter lists similar to the way you assign them to individual agents. 
With OracleApps lists, however, you have access to useful functions not available with individual connections. You can 
specify alternate connection(s) to run your jobs if the primary connection is unavailable or you can broadcast jobs to run 
on all the servers in the list at the same time.

From the 

pane, select 

to display the 

pane.

Right-click on the 

pane and select 

 from the context menu.

-or-

Click the 

 button on the Scheduler toolbar to display the

 dialog.

In the 

 field, enter the name of the OracleApps adapter list (up to 60 characters).

In the 

 field, you can select a parent list if you want to create nested lists.

If you specify a parent list, the list you are editing will be a child list of the parent and will appear below its parent in 
the list hierarchy.

From the 

 list, select the type of list based on how you want your jobs to be assigned to a PeopleSoft 

connection in the list.