Receive a sales contract from Oracle CPQ

Redwood Platform

Seamlessly transform sales agreement quotes in Oracle CPQ into sales contracts in Oracle Enterprise Contracts Management.

Use the new predefined Oracle CPQ message definition Oracle-1-0-A2A-CPQ-Sales-Contract-In to receive a sales agreement quote from Oracle CPQ and seamlessly transform them into the appropriate payload format required by Oracle Fusion Sales Contracts to create a sales contract.

You can now send status update notifications about the processing of the Oracle-1-0-A2A-CPQ-Sales-Contract-In message automatically to the initiating user in CPQ by leveraging the outbound application response message, Oracle-1-0-A2A-Application-Response-Out.

Here are some of the benefits of this feature:

  • Synchronized Transformation: Convert CPQ sales agreement quotes into Oracle Fusion sales agreement contracts through a cross-application flow, reducing integration effort and enabling consistent pricing from negotiation through order execution.
  • Automated Notifications: Success and error notifications are automatically handled and communicated back to Oracle CPQ so that the users are kept informed in real-time.

Steps to enable and configure

After you have enabled the feature Simplify Configuration and Processing for B2B Messaging, you'll need to perform the following high-level tasks to complete the setup:

  1. Select Connections from the in-app navigation bar.
    • Select the Providers tab and search for Oracle CPQ to see the service provider details.

Oracle CPQ Provider

Oracle CPQ provider

    • Select the Delivery Methods tab to access the predefined delivery method ORA_CPQ_REST_WebService.

Oracle CPQ Delivery Method

Oracle CPQ delivery method

    • Select the Connections tab and filter by the provider Oracle CPQ to see all seeded connections. ORA_CPQ_Oracle-1-0-A2A-Sales-Contract-In and ORA_CPQ_Oracle-1-0-A2A-Application-Response-Out are the connections related to this feature.

Oracle CPQ Messages

Oracle CPQ messages

  1. Select Documents from the in-app navigation bar.
    • Select the B2B Message Processing Result - Outbound document and set the Enabled field to Yes. You don’t need to assign a connection to this outbound document.

B2B Message Processing Result - Outbound

B2B message processing result - outbound

    • Filter by Inbound documents.
    • Select the Sales Contract - Inbound document and set the Enabled field to Yes.

Sales Contract - Inbound

Sales contract - inbound

  1. You can also search for Oracle CPQ message definitions by provider in B2B Message Definitions
    • Select Definitions from the in-app navigation bar.  
    • Select Oracle CPQ in the Provider filter. Oracle-1-0-A2A-CPQ-Sales-Contract-In and Oracle-1-0-A2A-Application-Response-Out definitions are the ones applicable to this feature.

Oracle CPQ Message Definitions

Oracle CPQ message definitions

  1. You can include additional attributes in your messages:
    • Select Definitions from the in-app navigation bar.
    • Select the predefined message definition you intend to customize, that is Oracle-1-0-A2A-CPQ-Sales-Contract-In or Oracle-1-0-A2A-Application-Response-Out, and select Export Transformation Package. The transformation package has two folders: mappingFile and mappingFunctionFile.
    • Edit the mapping file to include the additional attributes.
    • Edit the mapping function file to edit or create business functions used by the mapping file.
    • Select the predefined message definition you customized the mappings for (For example, Oracle-1-0-A2A-CPQ-Sales-Contract-In) and select Duplicate. Enter a name and upload your modified file. 

Duplicate Message Definition

Duplicate message definition

  1. You can replace the predefined message definition, Oracle-1-0-A2A-CPQ-Sales-Contract-In or Oracle-1-0-A2A-Application-Response-Out, with the newly duplicated one.
    • Select Connections from the in-app navigation bar.
    • Select the Connections tab and filter by the provider Oracle CPQ to see the connections for all Oracle CPQ messages.
    • Select the predefined ORA_CPQ_Oracle-1-0-A2A-Sales-Contract-In connection. The duplicated message will appear in the Message Definition drop-down list.

Replace Message Definition

Replace message definition

  1. Transactions for both Sales Contract - Inbound and B2B Message Processing Result - Outbound can be reviewed using the Messaging History page and by selecting the applicable document.
    • Select History from the in-app navigation bar.
    • Filter the messages by Document, Provider, or Status Date.

Message History

Message history

Tips and considerations

  • The Application Provider Type which defines the Oracle CPQ provider is any internal Oracle application that you exchange messages with.
  • Since the CPQ delivery method (ORA_CPQ_REST_WebService) facilitates communication between two Oracle applications, REST service details are not displayed on the page.
  • Transformation mode displays options to specify whether the document will be transformed using an XSLT style sheet or a mapping file. For Oracle-1-0-A2A-CPQ-Sales-Contract-In and Oracle-1-0-A2A-Application-Response-Out messages, the transformation is performed using JSON instead of XSLT, so the transformation mode is set to mapping file.
  • The mapping file contains the attribute mappings and may utilize functions defined in the JavaScript file when necessary.
  • The mapping function file contains all the functions used by the mapping file. It encapsulates the business logic necessary to perform the mapping operations.
  • Even if only one file is modified, both the mapping file and the mapping function file must be uploaded when duplicating a message.
  • There's no need to configure Customer B2B Properties for the Oracle-1-0-A2A-CPQ-Sales-Contract-In message.
  • The B2B Message Processing Result - Outbound document is automatically generated in response to the processing of the Sales Contract - Inbound (Oracle-1-0-A2A-CPQ-Sales-Contract-In) document. There's no need to assign connections to it.
  • All error information from the application will be available in the payload with the specific error message being extracted and displayed separately.
  • The contract number created in Fusion Sales Contracts will be available in the transformed payload.
  • Documents associated with either Oracle-1-0-A2A-CPQ-Sales-Contract-In or Oracle-1-0-A2A-Application-Response-Out messages can't be reprocessed or resubmitted from the History page.

Access requirements

If you're using custom job roles, then you need to add privileges identified as new in this update as well as validate that you have the previously delivered privileges listed.

Privilege status Privilege name and code
Existing Invoke Collaboration Message Inbound Service
CMK_INVOKE_INBOUND_COLLAB_DOC_SERVICE_PRIV