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:
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"
} ]
}