1. Using the Oracle CPQ Adapter with Oracle Integration 3
  2. Create an Oracle CPQ Adapter Connection
  3. Prerequisites for Creating a Connection

Prerequisites for Creating a Connection

You must satisfy the following prerequisites to create a connection with the Oracle CPQ Adapter.

Register with the Oracle CPQ Site

After registration, you then receive an email with information that you use to create a connection on the Connections page. See Configure Connection Properties and Configure Connection Security.

Obtain the SOAP WSDL from the Oracle CPQ Site

  • Note the following details:

    • The WSDL must be generated by the Oracle CPQ site to integrate with Oracle Integration.

    • Web Services 2.0 must be used to generate the URL needed to generate the WSDL.

    • The Commerce SOAP server URL endpoint must be used to generate the URL needed to generate the WSDL.

    • The commerce process to integrate with Oracle Integration must be used to generate the URL needed to generate the WSDL.

    Oracle Integration uses the Oracle CPQ transaction WSDL to understand the valid data and operations provided by Oracle CPQ.

    To access the Oracle CPQ transaction WSDL:

    1. Log in to the Oracle CPQ site that you want integrate with Oracle Integration.

    2. To open the Admin home page, click Admin.

      The Admin home page appears.

    3. Under Integration Platform, click Web Services.

    4. For the Web Service Version, select 2.0.

    5. Ensure that the Commerce tab is the current tab.

    6. From the Process Name list, select the name of the commerce process to integrate with Oracle Integration.

    7. In the SOAP Server URL field, append ?WSDL to the end of the value.

      For example: https://site_URL/v2_0/receiver/commerce/processVarName?WSDL.

      where:

      • site_URL is the base URL of the Oracle CPQ site.

      • processVarName is the variable name of the selected commerce process.

      • Optional: To confirm that the URL is correct, open it in a web browser. A page of WSDL should appear.

      Use the URL you created as needed in Oracle Integration to reference the Oracle CPQ transaction WSDL.

Obtain the REST Catalog URL

You specify a REST catalog URL to access an Oracle CPQ application’s business resources for outbound connections. The REST catalog URL is formatted as follows:
http(s)://site_URL/rest/v3/metadata-catalog

where site_URL is the base URL of the Oracle CPQ site.

Note that:

  • Only a REST catalog with version 3 or above is supported.

  • You must be on Oracle CPQ release 2016R2 or above to use the REST catalog in the Oracle CPQ Adapter.