Install and Configure the Recipe

On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.

Install the recipe on your Oracle Integration instance. See Install a Recipe or Accelerator.

After you've installed the recipe, configure the following resources:

Configure the Oracle FTP Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    FTP Server Host Address Enter the host address of your sFTP server.
    FTP Server Port Enter 22.
    SFTP Connection Select Yes from the list.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select FTP Server Access Policy.
    User Name Enter the user name to connect to your sFTP server.
    Password Enter the password to connect to your sFTP server.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A message confirms if your test is successful.
  6. To return to the project workspace, click Go back Back icon.

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.

Configure the Lookup Table

Edit the ORCL-BRT-ERP_IMPORTJOURNAL lookup table and enter appropriate values.

  1. In the Lookups section, click the lookup name.
  2. Enter appropriate values in the Property_value column for the following properties.
    Property_name Property_value
    outputDirectoryOnFTP Enter the path of the output directory that you created on the FTP server. See Access Your FTP Server.
    emailTo Enter the email address where notifications errors have to be sent.
    uploadFileName Enter the name of the log file with the financial journal entries.
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.

Update Integration Properties

The Oracle ERP FTP Import Journal Callback integration flow contains the JobName integration property that has to updated with appropriate value.

  1. In the Integrations section, click Actions Actions icon on the integration flow, then select Update property values.
  2. In the Update property values panel, update the JobName integration property with appropriate value. The JobName integration property holds the name of the Oracle Enterprise Scheduler (ESS) job that you run in Oracle ERP Cloud.
  3. Click Submit.

    A message confirms that the integration property has been updated successfully.