Before You Install the Recipe

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

Configure Amazon S3

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

  1. Obtain your AWS access keys. See Prerequisites for Creating a Connection in Using the Amazon Simple Storage Service (S3) Adapter with Oracle Integration 3.
  2. Set up your Amazon S3 bucket where you want the resulting log file to be stored.
    1. Log in to your AWS Management Console at https://console.aws.amazon.com/.
    2. In the AWS Management Console, enter S3 in the search field at the top.
    3. Select S3 - Scalable Storage in the Cloud from the search results.
      The Amazon S3 page appears.
    4. Select an existing bucket.
      • Scroll to the Buckets section. All available buckets are listed under it.
      • Select a bucket.
    5. Alternatively, create and choose a new bucket.
      1. Click Create bucket.
      2. In the Create bucket dialog, enter a unique name for the bucket.
        Note some rules about naming an Amazon S3 bucket.
        • A bucket name should be unique across all Amazon S3 buckets.
        • Bucket names must be between 3 and 63 characters long.
        • Bucket names can consist only lowercase letters, numbers, dots (.), and hyphens (-).
        • You cannot write a bucket name as an IP Address, such as 192.168.0.1.
        • Bucket names must begin and end with a letter or number.
        • Bucket names should not contain two adjacent dots (.).
        • Bucket names should not end with -s3alias.
        • Bucket names should not start with xn--.
    6. In the AWS Region field, select a region from the drop-down list.
    7. In the Object Ownership category, leave it as recommended. We use it for controlling the access of the files by specifying roles. If ACLs are disabled, the bucket owner automatically owns and has full control over every object in the bucket.
    8. In Block Public Access settings for this bucket category, ensure that BLOCK ALL PUBLIC ACCESS is selected. If you want to host your static website in this bucket, you can change the settings later.
    9. In the Bucket Versioning category, choose Disabled. Bucket versioning is helpful when you want to track any changes in the file made, intentionally or unintentionally. You can see the previous versions of a file, retrieve it, restore it or preserve it.
    10. Leave other advanced settings as default.
    11. Click Create bucket. The new bucket is listed under the Buckets section.
  3. Note the AWS Region of the bucket.
    1. Select the bucket.
    2. Click the Properties tab, and note the AWS Region of the bucket.

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 in Using the Oracle ERP Cloud Adapter with Oracle Integration 3.

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 Amazon S3 bucket that you created in your Amazon S3 instance.