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.
    User Name Enter the user name 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 Shopify REST Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, in the Hostname field, enter the URL of your Shopify instance. For example: https://your_domain_name.myshopify.com/
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Leave Basic Authentication selected.
    Username Enter the API key obtained earlier. See Configure Shopify.
    Password Enter the Shared Secret obtained earlier.
  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 REST Trigger Connection

  1. In the Connections section, click the connection name.
  2. Click Save. If prompted, click Save again.
  3. 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.
  4. To return to the project workspace, click Go back Back icon.

Configure the FTP Connection

Use the following steps to configure the Oracle Connection_ERP_jsonL_Shopify Connection.

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    1. FTP Server Host Address: Enter the host address of your sFTP server.
    2. FTP Server Port: Enter 22.
    3. SFTP Connection: specify the value as Yes.
  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.
    Private Key File 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 the UCM Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the WSDL URL. For example: https://erp-hostname/idcws/GenericSoapPort?wsdl
  3. In the Security section, enter the following details:
    Field Information to Enter
    User Name Enter the user name 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 Tables

  1. In the Lookups section, click the lookup name.
  2. Enter the field names and corresponding values. Refer to the details provided for each table below.
    The recipe contains the following three lookup tables. Edit them as necessary.
    • ORACLE-BRT-PDH_SHOPIFY_CONSTANTS: Used to map WeightUnit of items in Shopify with the corresponding WeightUnit of items in Oracle ERP Cloud.
      Weight Unit in Oracle ERP Cloud Weight Unit in Shopify
      kg KILOGRAMS
    • ORACLE-BRT-ERP_Shopify_PdSync_Notification_Const: Used to configure the email address to which the error notifications are sent when the recipe fails.
      Email_Property Email_Value
      fromAddress Specify the email address from which the notification emails are sent. Enter an email address of your choice.
      toAddress Specify the email address to which the notification emails are sent. Enter an email address of your choice.
    • ORACLE-BRT-PDH_SHOPIFY_CONSTANTS_VARIANTS: Used to configure item variants based on item category.
      Item_Category_Code ItemEffCategory Variant_Options Variant_Option1 Variant_Option2 Variant_Option3
      Smartphone ItemEFFBsm_5Fvariants_5FatgPrivateVO ["Language","Color","Voltage"] _Language _Color _Voltage
      Smartwatch ItemEFFBsw_5Fvariants_5FatgPrivateVO [“Material”,”Color”] _Material _Color  
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.