3 Install and Configure the Recipe

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

  1. On the Oracle Integration Home page, scroll to the Accelerators & Recipes section.
  2. Click Search All.
    The list of available recipes is displayed.
  3. Find and select the recipe package that you want to install, then click Install Install icon..
    A message confirms that the recipe was successfully installed, and the recipe card shows In use.
  4. After the package is installed, click Configure Configure icon on the recipe card.

    The Configuration Editor opens, displaying all the resources of the recipe package. Configure the following resources before you activate and run the recipe.

Configure the Oracle REST OIC API Connection

  1. In the Configuration Editor, click the connection name.
  2. In the Connection Properties section, enter the following details:
    Field Information to Enter
    Connection Type Leave REST API Base URL selected.
    Connection URL Enter the host name of the Oracle Integration instance where you installed the recipe.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Basic Authentication.
    User Name Enter the user name of the Oracle Integration user account with the Service Invoker role. See System and Access Requirements.
    Password Enter the password of the Oracle Integration user account with the Service Invoker role.
  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 Configuration Editor, click Back Back icon . Click Save again if prompted.

Configure the Oracle MICROS Reporting and Analytics BI API Connection

  1. In the Configuration Editor, click the connection name.

    To learn more about the configuration, see Authenticate in the Business Intelligence API Guide.

  2. In the Connection Properties section, enter the following details:
    Field Information to Enter
    Connection Type Leave REST API Base URL selected.
    Connection URL

    Enter the domain used to log into the Reporting and Analytics instance.

    For more information, see Send Requests in the Business Intelligence API Guide.

  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select OAuth Custom Three Legged Flow.
    Authorization Request

    Enter the authorization request format.

    Example: https://BIAPI_IDM_Server_HOST/oidc-provider/v1/oauth2/authorize?response_type=code&client_id= client_id &scope=openid&redirect_uri=https://OIC_HOST/icsapis/agent/oauth/callback&code_challenge=code_challenge&code_challenge_method=S256

    Access Token Request

    Enter the access token request format.

    Example: -X POST -H 'Content-Type: application/x-www-form-urlencoded' -d 'grant_type=authorization_code&code=${auth_code}&redirect_uri=https://OIC_HOST/icsapis/agent/oauth/callback&code_verifier=code_verifier&client_id=client_id' https://BIAPI_IDM_Server_HOST/oidc-provider/v1/oauth2/token

    Refresh Token Request

    Enter the refresh token request format.

    Example: -X POST -H 'Content-Type: application/x-www-form-urlencoded' -d 'grant_type=refresh_token&refresh_token=${refresh_token}&redirect_uri=https://OIC_HOST/icsapis/agent/oauth/callback&code_verifier=code_verifier&client_id=client_id' https://BIAPI_IDM_Server_HOST/oidc-provider/v1/oauth2/token

    $auth_code code
    $access_token access_token
    $refresh_token refresh_token
    $expiry expires_in
    $token_type token_type
    access_token_usage -H Authorization: ${token_type} ${access_token}
  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 Configuration Editor, click Back Back icon . Click Save again if prompted.

Configure the Oracle ATP Cloud Connection MICROS

  1. In the Configuration Editor, click the connection name.
  2. In the Connection Properties section, enter the Service Name.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select JDBC Over SSL.
    Wallet Upload the wallet zip file.
    Wallet Password Enter the password for the wallet.
    Database Service Username Enter the service user name of the Database created for Oracle Integration on ATP.
    Database Service Password Enter the password of the Database created for Oracle Integration on ATP.

    Note:

    These configurations indicate a wallet-based connectivity to ATP. This may vary depending on the type of ATP and its authentication mechanism used in your instance. Configure the connection accordingly.

  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 Configuration Editor, click Back Back icon . Click Save again if prompted.

Configure the Lookup Table

Edit the ORACLE-BRT-Micros_ErrorNotification_Config lookup table and enter the necessary values.

  1. In the Configuration Editor, click the lookup table name.
  2. The ORACLE-BRT-Micros_ErrorNotification_Config lookup table contains the information needed to trigger the error handlers. Enter the required information for the following parameters:
    Parameter Information to Enter
    OIC The Oracle Integration Admin email address that must be notified on failures.
    ERP The Oracle Integration Admin email address that must be notified on failures.
    Micros The Oracle Integration Admin email address that must be notified on failures.
  3. Click Save. If prompted, click Save again.
  4. To return to the Configuration Editor, click Back Back icon . Click Save again if prompted.