Create EBS System Connections

An EBS Connector consists of a EBS system, Job Server, Queue, and, optionally, a Platform Agent for serving files.

Create an Oracle Applications System Object

  1. Navigate to "Environment > Oracle Applications".
  2. Choose New Oracle Applications System from the context menu.
  3. Fill in the fields Name (referred to as <ora_name>), JDBC Connect String, and Default Time Zone.
  4. If you registered the Platform Agent with the central Redwood Finance Automation server, select a Job Server as Spool Host.
  5. Click Save & Close.
  6. Navigate to Configure > Control > Job Servers.
  7. Choose Start from the context menu of the Job Servers named <ora_name>_ProcessServer.

Create the Credential for Oracle Applications

  1. Navigate to "Security > Credentials".
  2. 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

  1. Download the appropriate installer for your platform from "Configuration > Software".
  2. Navigate to Configure > Control > Job Servers.
  3. Choose New Job Server from the context menu, fill the Port field, select the appropriate platform; choose Next.
  4. Fill a name into the Name field, select or create a Partition for the Job Server, and select the OS Family; choose Next.
  5. Select a Native installer, choose Next.
  6. Transfer the Platform Agent binary to the Oracle Applications Application server and run it with administrative privileges.
  7. If you register the Platform Agent with the central Redwood Server, you specify the name of the Job Server in the Spool Host field of the Oracle Applications object (see Create an Oracle Applications System Object section below).
  8. If you choose not to register the Platform Agent with the central Redwood Server, you add RemoteHostName, RemotePort, and SharedSecret to the Job 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.

Start the Job Server

  1. Navigate to Configure > Control > Job Servers.
  2. Choose Start from the context menu of the Job Server <ora_name>_ProcessServer.
  3. Refresh the window until the Job Server is starting, if after two minutes the Job Server has not started, inspect the Operator Messages Monitor.

Submit a Test process

  1. Navigate to Configure > Automate > Job Definitions and choose Run from the context menu of System_OraApps_ConcurrentProgramImport.
  2. 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).
  3. On the Control tab, select the <ora_name>_Queue Queue served by the Oracle Applications Job Server and monitor the process until it reaches the status Completed, if the process reaches status Error, check "Monitoring > Operator Messages".