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 that you want to install, then click Get.

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

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

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

Configure the Rest MS SharePoint 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 the connection type.
    Connection URL Enter the connection URL. For example, https://sharepoint_domain.sharepoint.com.
  3. In the Security section, enter the following details.
    Field Information to Enter
    Security Policy Select OAuth Client Credentials.
    Access Token URI

    Enter the following URI. Replace client_id, client_secret, tenant_id, and resource_id with the values obtained while configuring SharePoint. 

    -X POST -H "Content-Type: application/x-www-form-urlencoded" -d 'grant_type=client_credentials&client_id=<client_id>@<tenant_id>&client_secret=<client_secret>&resource=<resource_id>/<sharepoint_domain>.sharepoint.com@<tenant_id>' https://accounts.accesscontrol.windows.net/<tenant_id>/tokens/OAuth/2
    Client Id Enter the client ID. See Configure SharePoint.
    Client Secret Enter the client secret. See Configure SharePoint.
  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 Invoke 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 Oracle CPQ instance URL. For example, https://OracleInstance.com/rest/v8/metadata-catalog. See Configure Oracle CPQ.
  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 in Oracle CPQ. See Configure Oracle CPQ.
    Password Enter the password of the account created for Oracle Integration in Oracle CPQ. See Configure Oracle CPQ.
  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 Trigger Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details.
    Field Information to Enter
    Connection URL Enter the Oracle CPQ instance URL. For example, https://OracleInstance.com/rest/v8/metadata-catalog. See Configure Oracle CPQ.
  3. In the Security section, enter the following details.
    Field Information to Enter
    Username Enter the user name of the account created for Oracle Integration in Oracle CPQ. See Configure Oracle CPQ.
    Password Enter the password of the account created for Oracle Integration in Oracle CPQ. See Configure Oracle CPQ.
  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 Adobe Sign Connection

  1. In the Connections section, click the connection name.
  2. In the Security section, enter the following details.
    Field Information to Enter
    Subdomain Enter the subdomain from the authentication URL.
    Client Id Enter the Adobe application ID. See Configure Adobe Sign.
    Client Secret Enter the Adobe application secret. See Configure Adobe Sign.
    Scope Enter the consented scopes. For example, user_login:self agreement_send:self agreement_read:self.
  3. Click Save. If prompted, click Save again.
  4. Click Provide Consent.
    1. In the Sign in dialog, enter your Oracle Integration user name and password, then click Sign in.

      You are redirected to the Adobe Sign login page.

    2. Enter your Adobe Sign account credentials, then click Continue.
    3. On the Adobe Sign authorization page, click ACCEPT.

      A message confirms that access to Adobe Sign is allowed. Return to the Adobe Sign Connection window in Oracle Integration.

  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 Microsoft SharePoint Invoke Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details.
    Field Information to Enter
    Tenant Id Enter the tenant ID. See Configure SharePoint.
  3. In the Security section, enter the following details.
    Field Information to Enter
    Client Id Enter the SharePoint client ID. See Configure SharePoint.
    Client Secret Enter the SharePoint client secret. See Configure SharePoint.
  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 Microsoft SharePoint Trigger Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details.
    Field Information to Enter
    Tenant Id Enter the tenant ID. See Configure SharePoint.
  3. In the Security section, enter the following details.
    Field Information to Enter
    Client Id Enter the SharePoint client ID. See Configure SharePoint.
    Client Secret Enter the SharePoint client secret. See Configure SharePoint.
    Client State Enter the secret key.
  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.

Update Integration Properties

Update the integration properties for the Oracle CPQ, SharePoint, and Adobe Sign integration flows.

  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 integration properties with appropriate values.
    1. Update the properties for the Oracle CPQ SharePoint QuoteProposalUpload integration.

      • WaitForSharePointRetry: Specifies the wait time between retries when an invoke fails. The default value is 30.

      • RetryCount: Specifies the number of retries when an invoke fails. The default value is 3.

      • notificationEmail: Specifies the email address to receive notifications of failed operations.

    2. Update the properties for the Oracle SharePoint Adobe ProposalSign integration.

      • SignerEmail: Specifies the email address used to identify and notify the designated signer.

      • waitForAgreement: Specifies whether the workflow waits for agreement completion before continuing. The default value is 10.

      • formField_top: Specifies the vertical offset from the top edge for the Adobe Sign signature form field.

      • formFeild_height: Specifies the vertical size of the Adobe Sign signature form field.

      • formField_left: Specifies the horizontal offset from the left edge for the Adobe Sign signature form field.

      • formFeild_pageNumber: Specifies the page number on which to place the Adobe Sign signature form field.

      • notificationEmail: Specifies the email address to receive notifications.

      • formFeild_width: Specifies the horizontal size of the Adobe Sign signature form field.

    Note:

    This recipe contains app-driven integrations. Update the property values before activating the integrations.
  3. Click Submit.

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