1. Using Financials for the Americas
  2. Integration with Third Party – Oracle ERP Integration Service

Integration with Third Party – Oracle ERP Integration Service

You can automate the data extract from the custom Oracle BI Publisher reports using Oracle ERP Integration Web Services.

The approach is to automate end-to-end orchestration using Oracle ERP integration services and avoid high touch integration scenarios for handling individual transactions.

This image displays the support for this approach:

This image displays the support for this approac.

To implement this approach:
  • Create a custom Oracle BI Publisher (or use existing/created on previous topic) report and the respective Enterprise Scheduler (ESS) job.
  • Invoke the Oracle ERP Integration Service to initiate the Send Fiscal Documents to Tax Authority ESS job.
  • Upon job completion, Oracle ERP Cloud notifies you through an asynchronous callback.
  • Callback provides the status and information to download the extracted data file from Oracle ERP Cloud.
  • Determine the errors and take the appropriate action, such as process data extracted for downstream applications.

    For more information on how to automate external data integration, see the SOAP Web Services for Oracle Financials Cloud guide at http://docs.oracle.com.

This image outlines the steps involved in the automated data import process:

This image shows how to implement the fiscal document remittance flow.

To automatically import data into Oracle ERP Cloud:
  1. Create the data file using the TaxAuthorityReturnImportTemplate.xlsm template – download this file from the File-Based Data Import for Oracle Financials Cloud guide at http://docs.oracle.com.
  2. Initiate the Oracle ERP Integration Service to import.
  3. Provide notification through asynchronous callback on completion.
  4. Deliver the import status and information using callback to access logs or errors.
  5. Review any errors, if applicable, and take the appropriate action for error resolution.
    Note: After completion, Oracle ERP Cloud extracts data from the interface and error tables, includes the ESS job log files, and uploads the files to the UCM server in a ZIP format. Once uploaded successfully to the respective UCM account, the corresponding data is purged from the interface and error tables.