3 Install and Configure the Recipe

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

  1. On the Oracle Integration Home page, in the Get started section, click Browse store.
  2. Find the recipe you want to install, then click Get.

    A message confirms that the recipe was successfully installed, and the recipe card shows In use.

  3. Click Configure Configure icon on the recipe to configure its resources.

    The project workspace opens, displaying all the resources of the recipe. Configure the following resources before you activate and run the recipe.

Configure the Oracle Intelligent Advisor Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, specify the Oracle Intelligent Advisor base URL in the Intelligent Advisor Hub URL field. For example: https://{your_site_interface}/opa-hub
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select OAuth Client Credentials.
    Access Token URI Enter https://{your_site_interface}/opa-hub/api/{version}/auth
    Client Id The name of the API client in Intelligent Advisor Hub.
    Client Secret The password for the API client in Intelligent Advisor Hub.
  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 CPQ 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 Catalog URL.
    Connection URL Enter the base URL of your Oracle CPQ instance.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Username Password Token.
    Username Enter the user name of the account created for Oracle Integration on the Oracle CPQ instance.
    Password Enter the password of the account created for Oracle Integration on the Oracle CPQ 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 Lookup Table

The recipe contains the following lookup tables: ORCL-BRT-CPQ_STATE_LOOKUP and ORCL-BRT-CPQ_COUNTRY_LOOKUP.

  1. In the Lookups section, click the lookup name.
  2. Edit the lookup tables with appropriate values.
    • The ORCL-BRT-CPQ_STATE_LOOKUP lookup table contains state code and state name. If you have Customers which have addresses that contain different states than the ones present in the lookup, add them in the lookup table.
    • The ORCL-BRT-CPQ_COUNTRY_LOOKUP lookup table key-value pairs of country code and country description. If you have Customers which have addresses that contain different countries than the ones present in the lookup, add them in the lookup table.
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.

Update Integration Properties

Update the integration properties of the integration flows in the recipe.

  1. In the Integrations section, click Actions Actions icon on the Oracle IA CPQ Save CPQ Transaction integration flow, then select Update property values.
  2. In the Update property values panel, update the pricebookvarname integration property by providing a valid price book name in the New value field.
  3. Click Submit.

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

  4. In the Integrations section, click Actions Actions icon on the Oracle IA CPQ Load CPQ Transaction integration flow, then select Update property values.
  5. In the Update property values panel, update the following integration properties.
    • pricebookvarname: This integration property holds the price book name.
    • limit: This integration property holds the requested page size. The property sets the limit for the maximum number of elements that the collection should return.
    • offset: This integration property holds the offset of the page. By default, the offset value is zero which means that the first page will be returned.
    • q: This integration property holds the product/item name. For example: AS09743 - Vision Cloud 250gb Backup.
  6. Click Submit.

    A message confirms that the integration properties have been updated successfully.