Before You Install the Recipe

You must perform the following configuration tasks on your FTP server, Oracle ATP, Oracle ERP Cloud and Oracle Accounting Hub instances to successfully connect to Oracle Integration and create accounting journal entries.

Access Your FTP Server

Obtain an FTP server and ensure that you can access it.

  1. Login to the server using your username and password through an FTP client; for example, FileZilla.
  2. Create an input folder to store the transaction data files. Note down the path of the folder.
  3. Upload the transaction data files into the input folder.
You can also choose to store the input transaction data files to work with on File Server, an embedded sFTP server within Oracle Integration. To use File Server, you must enable it for your Oracle Integration instance. See Enable File Server in Using File Server in Oracle Integration 3.

Configure Oracle ATP

Log in to your Oracle ATP database instance as an Administrator and perform the following tasks.
  1. Perform general configuration tasks. See Prerequisites for Creating a Connection.
  2. Create a schema named accountinghub.
  3. Create a database table under the accountinghub schema.
    Create Table V_JOBS_STATUS(RequestID VARCHAR2 (50),ERPStatus VARCHAR2 (50),Processed VARCHAR2 (50))
For more information, refer to Oracle Autonomous Database documentation.

Configure Oracle ERP Cloud

To access the Oracle ERP Cloud instance from Oracle Integration, you’ll require a separate user account on Oracle ERP Cloud.

Log in to your Oracle ERP Cloud instance as an Administrator and perform the following tasks.
  1. Create a user account for Oracle Integration. Make a note of the user name and password you set for the account. You’ll use the credentials of this user account to connect to Oracle ERP Cloud from Oracle Integration.
  2. Assign required roles to the user account.
    1. Create a new job role under role category Common - Job Roles.
    2. Under role hierarchy, add the following duties:
      • ORA_XLA_ACCOUNTING_HUB_INTEGRATION_DUTY
      • ORA_XLA_ACCOUNTING_HUB_INTEGRATION_DUTY_OBI
      • FIN_FUSIONACCOUNTINGHUB_IMPORT_RWD
    3. Save the job role.
    4. Assign the job role to a user.
    5. Run the following jobs:
      • Send Pending LDAP Requests
      • Retrieve Latest LDAP Changes
      • Import User and Role Application Security Data

Configure Oracle Accounting Hub

To configure Oracle Accounting Hub, you have to complete three primary steps.

  1. Create a new sub-ledger application by registering the transaction source system using a spreadsheet.
  2. Configure accounting rules.
  3. Upload transaction data to create accounting entries.
For more information, refer to the following: