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 Amazon S3 Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Connection Type Select REST API Base URL.
    Connection URL Enter the Amazon S3 connection URL: https://s3.<your-bucket-region>.amazonaws.com/
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select AWS Signature Version 4.
    Access Key Enter the access key that you obtained. See Configure Amazon S3.
    Secret Key Enter the secret key that you obtained.
    AWS Region Select the AWS region where you have created the Amazon S3 bucket.
    Service Name Select Amazon Simple Storage Service (Amazon S3).
  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 the Oracle ERP Cloud Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the Oracle ERP Cloud host name. For example: https://your_domain_name.fa.DC.oraclecloud.com.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Username Password Token.
    Username Enter the username of the account created for Oracle Integration on Oracle ERP Cloud. See Configure Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on Oracle ERP Cloud.
  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 the Lookup Table

Edit the ORCL-BRT-S3_IMPORT_JOURNAL_SETTINGS lookup table with 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
    EmailErrorNotificationTo Enter the email address where notifications will be sent in case of integration errors.
    amazonS3ImportFileName Enter the name of the financial journal file that have to be imported into Oracle ERP Cloud from the Amazon S3 bucket.
    amazonS3BucketName Enter the name of the Amazon S3 bucket.
    amazonS3UploadFileName Enter the name of the log file that has to be send back to the Amazon S3 location.
  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 AS3 ERP Journal Entry Import 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.