Install and Configure the Integration in OIC

This section describes how to install the integration package in Oracle Integration Cloud (OIC).

You must download and import the integration packages and then configure settings in OIC.

Download and import the integration

The integration package includes two integrations:

  • Oracle_CXCommerce_SubscriptionCloud_Integration is the main integration. It contains all the subscription flows, such as create, modify, terminate, suspend, resume, and renew.
  • Oracle Financials Bill To Account is the integration flow that is called from the main Subscription flow.

To download the integration package, find the Oracle_CXCommerce_SubscriptionCloud_Integration.par on the Oracle Cloud Marketplace and download it to your local system.

To import the OIC Integration Package:

  1. Log on to OIC as an admin user.
  2. Click the Packages icon.
  3. Click the Import button.
  4. Click Browse to open a navigation pane.
  5. Select the integration package archive (PAR) file you want to import.
  6. Click Import.

    The package is added to the Packages list.

Configure the connections

After you install the Oracle_CXCommerce_SubscriptionCloud_Integration.par package, you must configure the connections used by the integration.

  1. Log in to OIC as an admin user.
  2. Select Integration->Connections.
  3. Select Oracle Commerce. The Connection Properties dialog appears.
    • Enter the URL to connect to Oracle Commerce as the value of the Connection Base URL property (https://<hostname>/ccadmin/v1).
    • Enter the security token value, which you can find in the Oracle Commerce administration settings and click OK. The security token is the application key in the Oracle Commerce administration interface, under Registered Applications Settings. Contact your Oracle Commerce administrator to get this application key.
  4. Select Sample Sales Cloud. This is connection to Oracle Subscription Cloud.
    • Enter the Subscription Cloud Services Catalog WSDL URL, Interface Catalog URL, and the Security (Username Password Token). For example:

      OSC Services Catalog WSDL URL: https://host/fscmService/ServiceCatalogService?wsdl

      Interface Catalog URL: https://host/helpPortalApi/otherResources/latest/interfaceCatalogs

  5. Select Oracle Engagement Cloud. This is connection to Oracle Customer Data Management.

    Enter the OSC Services Catalog WSDL URL, Interface Catalog URL, and Security (Username Password Token). For example:

    OSC Services Catalog WSDL URL: https://host/fscmService/ServiceCatalogService?wsdl

    Interface Catalog URL: https://host/helpPortalApi/otherResources/latest/interfaceCatalogs

  6. Select Oracle REST Trigger Employee Service. This is the trigger connection for the child integration Oracle Financials Bill To Account Integration. No configuration is necessary; just test and save the trigger.
  7. Select CDM_AR. This is connection to Oracle Financials Accounts Receivable.

    Enter the WSDL URL and Security (Username Password Token). For example: https://host/foundationParties/CustomerAccountService?WSDL

Assign values to constants in OIC integration flows

The following table describes the default constants values in the integration flows. You must change these default values so they match your system values.

Constant Value
subscriptionProfile zOSS_SP_ServiceStartFixed_Advance_Month
InternalApproval NOTREQUIRED
SourceSystem CX_CLOUD_COMMERCE
GenerateBillingSchedule Y
GenerateBillingScheduleForfullperiod Y
ChargeDefinition QP_RECURRING_SALE_PRICE, QP_SALE_PRICE
ExternalKey Recurring fee, Activation fee
ExternalParentKey Mapped to catalogRefId in order payload
PriceSystem CPQ
name Activate , resume, suspend and close
RelationShipTypeCode RENEW, AMEND
PriceType ORA_ONE_TIME, ORA_RECURRING

The constants are configured in mappers of different action nodes, such as createSubscriptions_OSS, SuspendProduct, and ResumeProduct. Follow these steps if you need to update any of the default values in the mapper:

  1. Log into Oracle Integration Cloud (OIC).
  2. Go to the integration Oracle CX Commerce To Subscription Integration.
  3. Edit the mapper of the action node for which you want to update the constant. Enter the new value in respective mapping.
  4. Save and close.

Configure lookups

You must update the following lookup tables to map the following relationships:

  • Site Merchant Details – Provides a mapping relationship between Site id, Definition Organization ID, Business Unit ID and Legal entity ID.
  • Payment Methods – Provides a mapping relationship between the payment method terms in Commerce and Oracle Subscription Management Cloud.
  • Reason_CreditMethod_Lookup – Provides a mapping relationship between the action code of items and their default reason for some asset-based-order actions and their corresponding credit methods.
  • Duration_OCC_OSS – Provides the mapping relationship between the duration terms in Commerce and their corresponding time code units in Oracle Subscription Management Cloud.

Activate the integration flows

After you configure the Oracle Subscription Management Cloud and Oracle Commerce connections, you must activate the integrations that were created when the integration package was imported to Oracle Integration Cloud. To do this, follow these steps:

  1. Log in to Oracle Integration Cloud (OIC) as an admin user.
  2. Click Integrations.
  3. Select each of the following integrations and click its Activate button.

    Oracle CX Commerce To Subscription Integration

    Oracle Financials Bill To Account Integration

OIC displays a message to indicate that the integration flow was successfully activated.