REST API for Oracle Fusion Cloud Financials

Import Financials Data

Use the ERP Integration REST API resource to import high-volume master or transaction data. You can run regular recurring imports of financial data across multiple products and transactional flows.

Use the import bulk data operation to deliver high-volume data across your organization. You can import data from on-premise or external business systems into Oracle ERP Cloud.

What type of data can you import? Here are some examples:

Daily supplier payables invoices from legacy and other external invoice feeder systems.
Recurring billing transactions that originate from on-premise or PaaS-based applications.
Claims generated from on-premise insurance claim processing applications, which require the creation of Payables invoices for remitting payments.
Journal entries from legacy applications.

Here's how you import data into Oracle ERP Cloud:

Create the data file using the applicable inbound business object template.
Call the ERP Integration REST API to initiate the import.
Provide notification through asynchronous callback upon completion.
Deliver the import status and information using callback to access logs or errors.
Review any errors and take the appropriate action.

This flowchart shows you how data is imported:

The diagram outlines the automated data import process, which involves creating a data file, calling the ERP integration import service, receiving callback upon completion, and delivering the import information.

Import Supplier Payables Invoices

Let's consider this import scenario for your supplier invoices.

Requirement

Description

Data

High volume of supplier invoices

Frequency

Daily

Source

Legacy or external feeder system

Target

Oracle Payables Cloud

Condition

Must be completed up-front to validate, account, tax, and pay all invoices as part of the regular procurement process.

To start, run a POST action method for the importBulkData action.

Example URL

Here's an example of the resource URL:

POST

fscmRestApi/resources/11.13.18.05/erpintegrations/importBulkData

Example Request

Here's an example of the request body:

{
    "OperationName":"importBulkData",
"DocumentContent":"UEsDBBQAAAAIAHSsJUWkOHOwEwEAAHgDAAAXAAAAQXBJbnZvaWNlc0ludGVyZmFjZS5jc3bV0LFOwzAQBuAdiXewOjBdU5/ts+MxNICCIEKEIjEG4SEijUrsCMHT47ZEqpCyIBj6Tzf8urM/JETOORSXV+x88E3nvGerrgmwvMmK2wrGgraWJwIER7VAseAGgvPBdcH1m77xjj3X3Ss7Y6EffAAtSBmEVFhjJKyqHN4AqoeszLP7HID0HEmmljRk5RMU67V7aergIGa8IHE/x1NxPhwngsBjBBdG8jlCAn+XizI/PdlJSDtNNRZQUnzI90f4SLWph5aFiOR637qPSJRK5JBKo8SeqD4kknoutFWpmiCKa39LhAqJ4vp/IlJymmgskP5JNNsaPTauZXcJW9b+3bUtsOs+mW2ljKQolRKpndTn0Ut9AVBLAwQUAAAACAAze2pIXdvnRHQAAACpAAAAEQAAAEFQVEVTVC5QUk9QRVJUSUVTdYrBCoMwEER/Reg1sPQTQgklYFVoatvjNqSwEDYhK4J/b9CrXmYeMy8V9DEA5iwQROBPjOwJo0DGBX8xCBDPiXyFqSAL+okSi9LDx9rH4Co483Tq0r3aVo0k9W36HApu3r6fpu3G3t5Mc9fOvPX3wLjuvQJQSwECFAAUAAAACAB0rCVFpDhzsBMBAAB4AwAAFwAAAAAAAAAAACAAAAAAAAAAQXBJbnZvaWNlc0ludGVyZmFjZS5jc3ZQSwECFAAUAAAACAAze2pIXdvnRHQAAACpAAAAEQAAAAAAAAAAACAAAABIAQAAQVBURVNULlBST1BFUlRJRVNQSwUGAAAAAAIAAgCEAAAA6wEAAAAA",
    "ContentType":"zip",
    "FileName":"APTEST_0310.zip",
    "JobName":"oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader,InterfaceLoaderController",
    "ParameterList":"1,7584,N,N"
}

Example Response

Here's an example of the response body:

{
  "OperationName" : "importBulkData",
  "DocumentId" : null,
  "DocumentContent" : "UEsDBBQAAAAIAHSsJUWkOHOwEwEAAHgDAAAXAAAAQXBJbnZvaWNlc0ludGVyZmFjZS5jc3bV0LFOwzAQBuAdiXewOjBdU5/ts+MxNICCIEKEIjEG4SEijUrsCMHT47ZEqpCyIBj6Tzf8urM/JETOORSXV+x88E3nvGerrgmwvMmK2wrGgraWJwIER7VAseAGgvPBdcH1m77xjj3X3Ss7Y6EffAAtSBmEVFhjJKyqHN4AqoeszLP7HID0HEmmljRk5RMU67V7aergIGa8IHE/x1NxPhwngsBjBBdG8jlCAn+XizI/PdlJSDtNNRZQUnzI90f4SLWph5aFiOR637qPSJRK5JBKo8SeqD4kknoutFWpmiCKa39LhAqJ4vp/IlJymmgskP5JNNsaPTauZXcJW9b+3bUtsOs+mW2ljKQolRKpndTn0Ut9AVBLAwQUAAAACAAze2pIXdvnRHQAAACpAAAAEQAAAEFQVEVTVC5QUk9QRVJUSUVTdYrBCoMwEER/Reg1sPQTQgklYFVoatvjNqSwEDYhK4J/b9CrXmYeMy8V9DEA5iwQROBPjOwJo0DGBX8xCBDPiXyFqSAL+okSi9LDx9rH4Co483Tq0r3aVo0k9W36HApu3r6fpu3G3t5Mc9fOvPX3wLjuvQJQSwECFAAUAAAACAB0rCVFpDhzsBMBAAB4AwAAFwAAAAAAAAAAACAAAAAAAAAAQXBJbnZvaWNlc0ludGVyZmFjZS5jc3ZQSwECFAAUAAAACAAze2pIXdvnRHQAAACpAAAAEQAAAAAAAAAAACAAAABIAQAAQVBURVNULlBST1BFUlRJRVNQSwUGAAAAAAIAAgCEAAAA6wEAAAAA",
  "FileName" : "APTEST_0310.zip",
  "ContentType" : "zip",
  "FileType" : null,
  "DocumentAccount" : null,
  "Comments" : null,
  "ProcessName" : null,
  "LoadRequestId" : null,
  "JobPackageName" : null,
  "JobDefName" : null,
  "ReqstId" : "316",
  "RequestStatus" : null,
  "JobName" : "oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader,InterfaceLoaderController",
  "ParameterList" : "1,7584,N,N",
  "NotificationCode" : null,
  "CallbackURL" : null,
  "JobOptions" : null,
  "StatusCode" : null,
  "ESSParameters" : null,
  "links" : [ {
    "rel" : "self",
    "href" : "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/erpintegrations/importBulkData",
    "name" : "erpintegrations",
    "kind" : "item"
  }, {
    "rel" : "canonical",
    "href" : "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/erpintegrations/importBulkData",
    "name" : "erpintegrations",
    "kind" : "item"
  } ]
}