The Oracle Applications Connector
You can connect Redwood Finance Automation to instances of Oracle Applications and schedule the workload seamlessly. The interface allows you to import Oracle Applications processes and trigger these from within Redwood Finance Automation according to the advanced scheduling rules that you can define in Redwood Finance Automation. All Oracle Concurrent Manager programs that can be started from Oracle's web submit screen (for submitting concurrent programs) can also be scheduled by Redwood Finance Automation.
To connect to instances of Oracle Applications, you need a free slot in the ProcessServerService.OraApps.limit and ProcessServerSerice.OS.limit.
| Capability | Description |
|---|---|
| Import Workload | You import any of the supported workload |
| Hold Workload | Using patterns you specify which workload to put on hold; this affects workload scheduled using Oracle Concurrent Manager |
| Monitor Workload | Using patterns you specify which workload to monitor; this affects workload scheduled using Oracle Concurrent Manager |
| Schedule Workload | Using time windows, process definitions, and events, you can create complex workload schedules seamlessly |
Prerequisites
- Oracle Applications 11.5 or higher
- Oracle database 8.1.7.4 or higher, an Oracle 8 database requires the 10.2.0.4 Oracle database client (JDBC)
- You have installed Redwood Finance Automation on Redwood Platform
- You have the credentials for an Oracle user that has necessary privileges to connect to the database
Architecture
Redwood Finance Automation creates a database connection to the Oracle Applications database using JDBC. Redwood Finance Automation uses this database connection to monitor, submit, and intercept jobs in Oracle Applications. This link is also used to import jobs from the Oracle Applications system.
The Oracle database housing the Oracle Applications system requires a Redwood package and a set of triggers, used for job interception.
The triggers are responsible for intercepting the Oracle Applications jobs, together with the package. The triggers and package also report back status information of monitored/controlled jobs running in the Oracle Applications system.
Oracle Drivers
Redwood Finance Automation connects to the Oracle Applications instance using an Oracle database driver for Java (jdbc). You must ensure that you have the correct Oracle driver in your classpath for the underlying Oracle database; note that the 11g Oracle driver does not support old Oracle databases.