Cisco Cisco Workload Automation 6.3 User Guide

Using the Oracle Applications Adapter

Creating an Oracle Applications Job



Verify that you can log into the Oracle instance from all clients that will modify job parameters. (Refer to your Oracle 
Applications documentation for more information.)



License the Oracle Applications Adapter for CWA. (Refer to “Licensing an Adapter”.)



Verify that the database alias entry for the Oracle Applications database in the tnsnames.ora is the same for the 
master and all client machines. (Refer to your Oracle database documentation for more information.)



Install Oracle Net*8 database connectivity software on each master and its clients.



Provide the CWA master or client with the alias listed in the tnsnames.ora file. (Refer to 

.)



Ensure that there is no other user called 

. The Bridge installation creates a user called 

 and if a user 

called 

 already exists the Bridge installation will fail.



Ensure the user account installing the Oracle Applications adapter has Administrator or Super User capabilities. 
(Refer to 



Add the Oracle Applications database user to CWA as a CWA user. (Refer to 

This integration does not place any significant resource requirements on any of the systems beyond what is expected by 
normal operation of the CWA and Oracle Applications products. Refer to the documentation of CWA and Oracle 
Applications to determine your actual system requirements. 

Creating an Oracle Applications Job

You can start creating and scheduling Oracle Applications jobs once you have:



Installed the Bridge component.



Applied the Oracle Applications license file.



Added the Oracle Applications database user to CWA.



Defined your Oracle Applications connection(s).

This section describes:





Defining an Oracle Applications Job

You can add an Oracle Applications job using the right-click menu within the Job Rules window and selecting the 

 option. You can also 

 and 

 an existing Oracle Applications job. If you add Oracle 

Applications jobs to a CWA job group, items common between the job group and the Oracle Applications job are 
inheritable. However, unless the parent group has an Oracle Applications agent assigned to it, you must clear the 

 option and select the correct Oracle Applications connection.

To define a job in Oracle Applications, you need to go to Oracle’s website to download and install Oracle’s JInitiator 

component. Before installing the JInitiator, go to the Internet options for your browser and on the Security tab, adjust the 
security level for the internet to the Low setting. After downloading the JInitiator, reset the internet security setting to its 
original configuration. 

From the 

 pane, select 

 to display the 

 pane.