Cisco Cisco Workload Automation 6.3 User Guide

www.cisco.com

Configuring the Oracle Applications 
Adapter

Overview

The Oracle Applications Adapter software is installed as part of a standard installation of Cisco Workload Automation. 
However, before the Oracle Applications Adapter can be used, the following configuration procedures must be 
completed:



—Install the Oracle Applications Bridge (install_11i or install_R12).



—License the Oracle Applications Adapter to work with CWA.



—Define a security policy for running Oracle Applications jobs.



—Define a user account that can access the Oracle 

database.



—Authorize users to run Oracle Applications jobs using the database user account.



—Obtain, export, and import the 

security certificate into the Java keystore.



—Define a connection to the Oracle database.



—Configure Oracle to work with CWA.

See 

 for information about general and adapter-specific properties that can be set to 

control things like logging and connection properties. 

Installing the Oracle Applications Bridge

There are two components to the Oracle Applications adapter. One component is the Oracle Applications adapter itself 
while the other part is a bridge component that provides a link between the adapter and the Oracle Applications program. 
The Oracle Applications adapter is part of the normal CWA installation and does not require a separate installation. 
However, the Bridge component does require installation and the procedure to install it is described in this section.

The Oracle Applications Bridge is comprised of various PL/SQL stored procedures and forms used to pass job 
parameters to the Oracle database. The Bridge component of the Oracle Applications adapter is not part of the regular 
CWA installation and requires a separate installation procedure. 

If you need to create a custom APPS user for CWA, then you also need to use a different installation process for 

the Oracle Applications Bridge as described in 

.