About This Recipe

This recipe imports and transforms transaction data received from external systems and creates accounting journal entries for the same in Oracle Accounting Hub.

To use the recipe, you must install the recipe and configure the connections and other resources within it. The recipe contains the following scheduled integration flows.
  • Oracle FTP ERP ImportAccountTransactions ESS Trigg - This integration flow imports the transaction data from an FTP server and writes the data into an Oracle ATP database table. It fetches the data stored in the Oracle ATP database table and uploads it to Universal Content Management (UCM) using the Oracle ERP adapter. It then places a request to submit a Enterprise Scheduler Service (ESS) job and inserts the ESS job request id to the Oracle ATP database.
  • Oracle ERP AccountTransactions ESS Job Monitor - This integration flow gets each request id from the Oracle ATP database table and queries for the ESS job status in Oracle ERP Cloud. If the status is successful, it sends the data to Oracle Accounting Hub where a corresponding accounting journal entry is created.

Prerequisite: For the recipe to run successfully, the transaction data received from external systems have to be uploaded to the FTP server in a particular format. Download the XlaTransactionUploadTemplate99.zip for standard transaction header, line and metadata file templates that can be used to upload the required transaction data (from external systems) to the FTP server.

System and Access Requirements

  • Oracle Integration, Version 24.10 or higher

  • Oracle Accounting Hub

  • An account on Oracle Accounting Hub with the Administrator role

  • Oracle ERP Cloud

  • An account on Oracle ERP Cloud with the Administrator role

  • Oracle ATP

  • An account on Oracle ATP with the Administrator role

  • A secure FTP (sFTP) server or File Server

  • An FTP client to access the sFTP server