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 .

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 .

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 .

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

1. In the Integrations section, click Actions 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 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.