Oracle CPQ integration with Oracle E-Business Suite

Configure Price Quote (CPQ), or Big Machines (before the Oracle acquisition) helps companies improve margins and increase sales productivity. It is a flexible, scalable, enterprise-ready solution that enables organizations to accurately capture orders for complex products/services and generate quotes within minutes.

Let us consider a typical sales cycle wherein the customer calls the sales person and requests a quote for a product. The sales person logs in to the CPQ Cloud application and prepares the quote. This product can either be available off-the-shelf or has to be assembled based on the customer’s requirements. As part of the quotation process, CPQ gets the product’s and/or its components information from back end system like E-Business Suite (EBS) or other SCM applications. Once the quote is completed it is sent to the customer and when it is approved, the sales person converts the quote into an order. At this point, CPQ submits the order to EBS for its fulfillment to the customer.

There are two integration points in the above scenario. The first integration point is when CPQ has to pull information from EBS like product availability, product price etc. and the second is when CPQ has to push information into EBS when submitting an order. In both cases, EBS will have Web Service API interfaces for CPQ to call. We have implemented the push-integration of calling EBS web service to submit an order from CPQ.

When an quote is submitted to create and order, an ‘order_action’ process begins in CPQ. This ‘order_action’ is configured to call a BML (Business Markup Language) function ‘InvokeWebService’, This BML function is configured to call EBS Web Service URL defined in CPQ’s ‘INT_SYSTEM_DETAILS’ data table. The quote data is defined as a SOAP packet and sent to EBS as body of the web service call. All the mapping between the CPQ Quote fields and EBS order fields are implemented in this web service. Once the order is created in EBS, order information is returned to CPQ and displayed on Quote Transaction Page.

All information is encrypted and transmitted over internet using SSL (Socket Secured Layer) over HTTPS.

In summary, key technical integration points between CPQ and EBS are:

Configuring CPQ’s ‘Order Start’ action to call BML function ‘Invoke Web Service’ method.
Defining BML Invoke Web Service method
Defining EBS Web Service in INT_SYSTEM_DETAILS data table
Develop EBS Web Service to implement mapping between CPQ Quote fields and EBS Order fields and create and order in EBS
Send the order information back to CPQ

Reach out to sales@ibizsoftinc.com to learn more about the integration between Oracle CPQ and E-Business Suite. http://www.ibizsoftinc.com/Demo/Integrating-Oracle-CPQ-with-Oracle-EBS.php