Before You Install the Recipe

You must perform the following configuration tasks on your FTP server and Oracle ERP Cloud instances in order to connect to these external systems using Oracle Integration, and successfully import financial journal entries from an FTP server to Oracle ERP Cloud.

Access Your FTP Server

Obtain an sFTP server and ensure that you're able to access it.

  1. Log in to the server using your user name and password through an FTP client; for example, FileZilla.
  2. Create an output directory (ftp-erp-transfer) on the server where the output log files from Oracle ERP Cloud must be uploaded . Note down the path of this directory.

Configure Oracle ERP Cloud

Complete the following configuration tasks on your Oracle ERP Cloud instance to connect to it from Oracle Integration, and import financial journal entries.

Perform the general configuration tasks for creating a connection. See Prerequisites for Creating a Connection.

Financial journal entries have to be in a particular format so that Oracle Enterprise Scheduler (ESS) Jobs can be run and the financial data can be finally stored in a log file. To enable this, you have to download the journal import template from Oracle ERP Cloud and prepare a journal import file based on it.

  1. Download the journal import template (JournalimportTemplate.xlsm).
    1. Navigate to Oracle Fusion Cloud Applications Suite in Oracle Help Center.
    2. Under Enterprise Resource Planning (ERP), click Financials.
    3. In the left navigation pane of the Oracle Financials Get Started page, click All Books.
    4. Under Implementation, open the File-Based Data Import (FBDI) for Financials guide.
    5. Under the General Ledger section of the guide, click Journal Import.
    6. In the File Links section, download the journal import template XLSM file (JournalimportTemplate.xlsm) and save it to your local machine.
  2. Prepare the journal import data file.
    1. Delete the sample data from the JournalimportTemplate.xlsm file. Keep only one record for your reference.
    2. Populate the file with a few financial journal entry records.
    3. Then, click and open the Instructions and CSV Generation sheet.
    4. Click Generate CSV File.
    5. Save the generated CSV file. It will be saved as a ZIP file on your local machine.
      Upload the data file to the input folder in your FTP server.