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 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 theOracle ERP Cloud instance. See Configure Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on the Oracle ERP Cloud instance.
  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 GCP Pub Sub Invoke Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Project Id Enter your GCP Pub Sub project Id. See Configure GCP Pub Sub.
    Service Account Enter GCP Pub Sub service account detail.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Google Client ID Enter the Google client ID. See Configure GCP Pub Sub.
    Google Client Secret Enter the Google client secret.
  4. Click Provide Consent to verify the connection properties and get an access token.
  5. Click Save. If prompted, click Save again.
  6. 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.

  7. To return to the project workspace, click Go back Back icon.

Configure the GCP Pub Sub Trigger Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Project Id Enter your GCP Pub Sub project Id. See Configure GCP Pub Sub.
    Service Account Enter GCP Pub Sub service account detail.
  3. In the Security section, enter the JWT Private Key Alias. See Configure GCP Pub Sub.
  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 Magento Commerce Cloud Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the Magento Commerce Cloud host name.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Consumer Key Enter the consumer key value. See Configure Magento Commerce Cloud.
    Consumer Secret Enter the consumer secret value.
    Access Token Enter the access token value.
    Access Token Secret Enter the access token secret value.
  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 Tables

Edit the lookup tables of the recipe with appropriate values.

  1. In the Lookups section, click the lookup name.
  2. The recipe contains the following two lookup tables.
    1. MagentoLookup: Use this lookup to configure Magento request parameters.
      Property Description Value
      Media Type Specify the media type of the attachment. image
      Label Specify the value of the label. image
      Disabled Specify the value either True or False. false
      Types1 Specify the type of the attachment. image
      Types2 Specify the type of the attachment. image_small
      Types3 Specify the type of the attachment. thumbnail
    2. QuickBooksLookup: Use this lookup to configure the QuickBooks request parameters.
      Property Description Value
      Income Account Ref Val Specify the income account reference ID. 79
      Income Account Ref Name Specify the income account reference name. Sales of Product Income
      Expense Account Ref Val Specify the expense account reference ID. 80
      Expense Account Ref Name Specify the expense account reference name. Cost of Goods Sold
      Asset Account Ref Val Specify the asset account reference ID. 81
  3. In the Value column of the lookup tables, enter or map the appropriate values for the properties.
  4. Click Save. If prompted, click Save again.
  5. To return to the project workspace, click Go back Back icon.