Redwood Documentation

Product Documentation

 

›Configuration of RFA

Finance AutomationOracle EBS Setup

Introduction

  • Introduction

The Oracle Applications Connector

  • The Oracle Applications Connector

Configuration of RFA

  • Configuration of Redwood Finance Automation
  • Create EBS system connections
  • Importing Oracle Applications Concurrent Programs
  • Importing Oracle Applications Functions and Procedures
  • Importing Oracle Applications Request Sets

Appendix: Reference

  • Oracle EBS Process Definitions
← Configuration of Redwood Finance AutomationImporting Oracle Applications Concurrent Programs →

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

  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 process server as Spool Host.
  5. Choose Save & Close.
  6. Navigate to "Environment > Process Servers".
  7. Choose Start from the context-menu of the process 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 "Environment > Process Servers".
  3. Choose New Process 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 process 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 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).
  8. 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

  1. Navigate to "Environment > Process Servers".
  2. Choose Start from the context-menu of the process server <ora_name>_ProcessServer.
  3. 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

  1. Navigate to "Definitions > Processes" and choose Submit 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 process server and monitor the process until it reaches the status Completed, if the process reaches status Error, check "Monitoring > Operator Messages".

See Also

  • Oracle Applications Connector
  • Connecting to Oracle Applications
← Configuration of Redwood Finance AutomationImporting Oracle Applications Concurrent Programs →
  • Create an Oracle Applications System Object
  • Create the Credential for Oracle Applications
  • Install a Platform Agent on the Oracle Applications Server
  • Start the Process Server
  • Submit a Test process
  • See Also
Docs
Getting StartedInstallationFinance InstallationConcepts
TroubleshootingArchiving
Learn and Connect
Support Portal
BlogEventsResources
ISO/ IEC 27001 Information Security Management
Automate to be human

2023 All Rights Reserved |

Terms of Service | Policies | Cookies | Glossary | Third-party Software | Contact | Copyright | Impressum |