Create EBS system connections
An EBS connector consists of a EBS system, process server, queue, and, optionally, a platform agent for serving files.
Create an Oracle Applications System Object
- Navigate to "Environment > Oracle Applications".
- Choose New Oracle Applications System from the context-menu.
- Fill in the fields Name (referred to as
<ora_name>
), JDBC Connect String, and Default Time Zone. - If you registered the platform agent with the central Redwood Finance Automation server, select a process server as Spool Host.
- Choose Save & Close.
- Navigate to "Environment > Process Servers".
- Choose Start from the context-menu of the process servers named
<ora_name>_ProcessServer
.
Create the Credential for Oracle Applications
- Navigate to "Security > Credentials".
- Choose New Credential from the context-menu, select OraApps as a protocol, fill the Oracle Applications object name into the Endpoint property and default into the Virtual Username field. Fill the username and password into the respective fields.
Install a Platform Agent on the Oracle Applications Server
- Download the appropriate installer for your platform from "Configuration > Software".
- Navigate to "Environment > Process Servers".
- Choose New Process server from the context-menu, fill the Port field, select the appropriate platform; choose Next.
- Fill a name into the Name field, select or create a partition for the process server, and select the OS Family; choose Next.
- Select a Native installer, choose Next.
- Transfer the platform agent binary to the Oracle Applications Application server and run it with administrative privileges.
- If you register the agent with the central Redwood Server, you specify the name of the process server in the Spool Host field of the Oracle Applications object (see Create an Oracle Applications System Object section below).
- If you choose not to register the platform agent with the central Redwood Server, you add RemoteHostName, RemotePort, and SharedSecret to the process server created by the Oracle Applications object. (see Create an Oracle Applications System Object section below).
note
You can use the default settings, on UNIX, you should ensure the user the jobs run under is a valid user. See the Creating Platform Process Servers topic for more information on installing platform agents.
Start the Process Server
- Navigate to "Environment > Process Servers".
- Choose Start from the context-menu of the process server
<ora_name>_ProcessServer
. - Refresh the window until the process server is starting, if after two minutes the process server has not started, inspect the Operator Messages Monitor.
Submit a Test process
- Navigate to "Definitions > Processes" and choose Submit from the context-menu of System_OraApps_ConcurrentProgramImport.
- Select the newly created Oracle Applications system, select an Application short name and Concurrent Program name; note that the values are retrieved from the remote Oracle Applications system; choose Next, and Next once more (you leave the defaults as the process should start immediately).
- On the Control tab, select the
<ora_name>_Queue
queue served by the Oracle Applications process server and monitor the process until it reaches the status Completed, if the process reaches status Error, check "Monitoring > Operator Messages".