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. See Configure Resources in a Package.

Configure the REST OIC API Connection

  1. In the Configuration Editor, under Connections, click the connection name.
  2. In the 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 in which you’ve installed the recipe.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Basic Authentication.
    Username Enter the user name of the Oracle Integration user account with the Service Invoker role.
    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 Go back Back icon.

Configure the REST KanbanBOX Connection

  1. In the Configuration Editor, under Connections, click the connection name.
  2. In the 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 your KanbanBOX instance.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select API Key Based Authentication.
    API Key Enter the API key obtained from the KanbanBOX instance. See Configure KanbanBOX.
  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 Go back Back icon.

Configure the ERP Cloud Connection KanbanBOX

  1. In the Configuration Editor, under Connections, click the connection name.
  2. In the Properties section, enter the Oracle SCM 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.
    Username Enter the user name of the account created for Oracle Integration on Oracle SCM Cloud. See Configure Oracle SCM Cloud.
    Password Enter the password of the account created for Oracle Integration on Oracle SCM 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 Configuration Editor, click Go back Back icon.

Configure the Lookup Tables

Edit the lookup tables and enter the necessary values.

  1. In the Configuration Editor, click Lookups to view the lookup tables in the recipe. Click the name of the lookup table to edit.
  2. This recipe package contains the following lookup tables.

    Oracle-BRT-ERP_KanbanBOX_WO_Config

    This lookup table contains the information needed to create a work order in Oracle Fusion Cloud Manufacturing. The following table provides the description for each parameter:

    Name Description
    WorkDefinitionCode

    The value of the Work Definition code used in the work order creation as configured on the Oracle Fusion Cloud Manufacturing instance.

    Example value: ORA_MAIN

    Note:

    Do not modify this value unless the Oracle Fusion Cloud Manufacturing configuration has changed.
    WorkOrderStatusCode

    The status of the work order created using the integration, which is predefined.

    Example value: ORA_RELEASED

    Note:

    Do not modify this value unless the Oracle Fusion Cloud Manufacturing configuration has changed.
    ExplosionFlag

    The value of the Explosion Flag set while creating the work order as configured on Oracle Fusion Cloud Manufacturing.

    Example value: TRUE

    Note:

    Do not modify this value.
    KanbanAdmin

    The Kanban Admin email ID that must be notified if there are errors while updating KanbanBOX.

    Example value: abc@xyz.com

    Update this value based on your KanbanBOX configuration.

    WONotificationUserName

    The user name of the Oracle Fusion Cloud Manufacturing user who receives the Fusion pop-up notifications on work order creation; this value is case -sensitive.

    Example value: Terry.Johnson

    Update this value based on the configuration in Oracle Fusion Cloud Manufacturing.

    TaskCreator

    The name of the task creator displayed in the Fusion pop-up notifications for work orders.

    Example value: Terry Johnson

    Update this value based on the configuration in Oracle Fusion Cloud Manufacturing.

    BatchCardLimit

    The threshold limit on the number of batch cards to be processed by Oracle Integration in a single Kanban release (via an integration call). Any incoming request having batch cards beyond this number is not processed by Oracle Integration.

    Example value: 5

    Update this value based on the configuration in Oracle Integration.

    OICAdminEmail

    The Oracle Integration Admin email ID that must be notified on failures.

    Example value: abc@xyz.com

    Update this value based on the configuration in Oracle Integration.

    Oracle-BRT-ERP_KanbanBOX_PO_Config

    This lookup table contains the information required to create a purchase order in Oracle Fusion Cloud Procurement. The following table provides the description for each parameter:

    Name Description
    ApproverEmail

    The email ID for the purchase order approval workflow as configured on Oracle Fusion Cloud Procurement.

    Example value: calvin.roth@oraclepdemos.com

    Update this value based on the configuration in Oracle Fusion Cloud Procurement.

    Description

    The description used in the mapping for the Requisition Header information.

    Example value: Requisition from KanbanBOX

    Update this value based on your requirements.

    DocumentStatusCode

    The standard value of the Document Status code while creating purchase requisitions as configured on Oracle Fusion Cloud Procurement.

    Example value: APPROVED

    Note:

    Do not modify this value.
    PreparerEmail

    The email ID of the purchase-requisition preparer, which is to be used in the mapping.

    Example value: Nash.Lans@oraclepdemos.com

    Update this value based on the configuration in Oracle Fusion Cloud Procurement.

    DestinationTypeCode

    The standard value of the Destination Type code to be used in the mapping while creating purchase requisitions.

    Example value: INVENTORY

    Note:

    Do not modify this value.
    KanbanAdmin

    The Kanban Admin email ID that must be notified if there are errors while updating KanbanBOX.

    Example value: abc@xyz.com

    Update this value based on your KanbanBOX configuration.

    PONotificationUserName

    The user name of the procurement manager in Oracle Fusion Cloud Procurement who receives the Fusion pop-up notifications on purchase order creation; this value is case-sensitive.

    Example value: nash.lans

    Update this value based on the configuration in Oracle Fusion Cloud Procurement.

    TaskCreator

    The name of the procurement manager (task creator) displayed in the Fusion pop-up notifications for purchase orders.

    Example value: Nash Lans

    Update this value based on the configuration in Oracle Fusion Cloud Procurement.

    OICAdmin

    The Oracle Integration Admin email ID that must be notified on failures.

    Example value: abc@xyz.com

    Update this value based on the configuration in Oracle Integration.

    BatchCardLimit

    The threshold limit on the number of batch cards to be processed by Oracle Integration in a single Kanban release (via an integration call). Any incoming request having batch cards beyond this number is not processed by Oracle Integration.

    Example value: 5

    Update this value based on your requirement.

    Oracle-BRT-ERP_KanbanBOX_PO_MasterData

    This lookup table contains the Requester information that’s used for creating the purchase requisition on Oracle Fusion Cloud Procurement. Update the requester details according to your implementation.

    Name Description
    RequesterEmail

    The email ID of the Requester used to create the purchase requisition.

    Example value: kanban.user@oraclepdemos.com

    Update this value based on the configuration in Oracle Fusion Cloud Procurement.

  3. Click Save. If prompted, click Save again.
  4. To return to the Configuration Editor, click Go back Back icon.