1. Import file-based data to Oracle Fusion Cloud Enterprise Resource Planning
  2. Upload the Data to Oracle Cloud ERP

Upload the Data to Oracle Cloud ERP

You must now create a flow to upload the data to Oracle Cloud ERP.

The next step is to consume the FBDI file generated by the previously described flow, and upload the file to Oracle Cloud ERP.

Oracle Cloud ERP exposes web services (mainly SOAP) that can be used for data transfer. While these services can be directly accessed using a SOAP call, there are some complexities involved in terms of dealing with binary files like a ZIP file to upload and receive data. Retrieving and uploading ZIP files using a simple SOAP call may be cumbersome. Fortunately, Oracle Integration has an ERP Adapter that abstracts several of these complexities. So, for the journal upload in this case, the ERP Adapter is used.

Description of journal-entry-2.png follows
Description of the illustration journal-entry-2.png

The two numbered steps in the image perform the following steps:

  1. Read the FBDI ZIP file.
  2. Invoke Oracle Cloud ERP using the ERP Adapter.

The Oracle Cloud ERP Adapter takes the ZIP file containing the FBDI file and Property File as input. Since the read activity reads the file, only the file reference and name need to be passed to the Oracle Cloud ERP Adapter.

Read the File-Based Data ZIP File

The first step of the flow is to read the FBDI ZIP file.

The flow is triggered by a scheduler. When the scheduler kicks off the process, the first activity reads the FBDI ZIP file created in the previous flow. Since the file is a ZIP file, no schema is needed to read it.

Use the Adapter to Upload the Data File

Invoke Oracle Cloud ERP by using the Oracle Cloud ERP Adapter.

To configure the Oracle Cloud ERP Adapter at design time, use the Oracle ERP Cloud Endpoint Configuration Wizard:

  1. In the Basic Info step, call the endpoint InvokeERP, optionally give it a description, and set the action to Import Data into Financials Cloud Application.
  2. In the Operations step, enter the Import Job Name with a value such as Import Journal. Optionally enter a description and set Extract File to All.
  3. In the Response step, set notifications according to your requirements, and then set the Callback information. Set Integration Flow Identifier and Version to the identifier and version of the callback Oracle Integration flow.
    The callback flow is described in the next article. You will need to create that flow and use its identifier here.