Standard Process Commerce Integrations

Overview

Beginning in Oracle CPQ 23B, the Standard Process provides predefined REST integrations to simplify setup for integrations between Oracle Sales and Oracle CPQ. Additionally, it provides several predefined BML integrations for order and subscription management. The Standard Process will include the Oracle integrations by default. Customers can add additional integrations in the Commerce Process and delete they can delete integrations that are not needed.

BML Type Integrations

Name	Description
Cancel Renewed Subscription	Cancels the draft renewal subscription in the external system.
Cancel SO From CPQ	Cancels the entire order or the specific lines in the external system.
Get SO Status From FOM	Gets Order status and Line status from an external system.
Update Asset	Performs asset creation in CPQ Cloud local repository and updates Fulfillment Status.
Update Fulfillment Line Status	Updates the fulfillment status and updates the asset for the line items in the external system.
Process Create Order Response	Processes REST response from Create Order ICS Integration and applies it to the transaction.
Publish And Notify Quote	Publishes the quote and notifies the buyer that the quote is ready for review.
TCA Account Integration	Retrieves Bill To, Sold To and Ship To customer information.
Update Asset	Performs asset creation in CPQ Cloud local repository and updates Fulfillment Status.
Update Customer Status And Visibility	Updates Customer Status and Customer Visibility Identifier based on current step for buyer/customer's view.
Update Fulfillment Line Status	Updates the fulfillment status and updates the asset for the line items in the external system.

REST Type Integrations

Import Revenue Lines

This integration imports revenue lines from an Oracle Sales opportunity and creates related quote lines on a CPQ transaction.

Type: REST - Import Revenue Lines
Timeout: 20000
ID Field: transaction.opportunityNumber_t
Endpoint URL: /crmRestApi/resources/11.13.18.05/opportunities/{opty_number}/child/ChildRevenue
MetaData URL: /crmRestApi/resources/11.13.18.05/opportunities/describe
Child Resource: ChildRevenue
Query Parameters:
- Key: q
- Value: SplitTypeCode!=DETAILCHILDSPLIT,RecurTypeCode!=CHILDRECUR
Batch Size: 500
Document: Sub Document

Response Mapping

CPQ Attribute			Mapping	Oracle Sales Attribute
Name	Variable Name	Type	Mapping	Display Name	Variable Name
Config Attribute Values	_config_attr_values	Text Area		Product Model Attributes	ProductModelConfigAttributes
Config Attribute Values	_config_attr_values	Text Area		Product Group Model Attributes	ProdGroupModelConfigAttributes
Contract End Date	contractEndDate_l	Date		Contract End Date	ContractEndDate
Contract Start Date	contractStartDate_l	Date		Contract Start Date	ContractStartDate
Instance ID	itemInstanceId_l	Text		External Asset Key	ExternalAssetKey
Model Name	_model_name	Text		Product Group	ProdGroupName
Model Name	_model_name	Text		Solution	Description
Model Partner Organization ID	model_parner_organization_id'	Text		Opportunity Revenue	inventoryOrgId
Model Product Line Variable Name	_model_product_line_var_name	Text		Product Group Model Line	ProdGroupModelLine
Model Product Line Variable Name	_model_product_line_var_name	Text		Product Model Line	ProdModelName
Model Segment Variable Name	_model_segment_var_name	Text		Product Group Model Family	ProdGroupModelFamily
Model Segment Variable Name	_model_segment_var_name	Text		Product Model Family	ProdModelFamily
Model Variable Name	_model_variable_name	Text		Product Group Model	ProductGroupModelName
Model Variable Name	_model_variable_name	Text		Product Model	ProductModelName
Parent Asset Key	parentAssetKey_l	Text		External Parent Asset Key	ExternalParentAssetKey
Partner Entity Id	_partner_entity_id	Text Area		Product	InventoryItemId
Partner Organization ID	oRCL_SFA_InventoryOrgID_l	Text		Product	InventoryOrgId
Quantity	_price_quantity	Integer		Quantity	Quantity
Revenue Category	_revenueCategory_l	Menu		Revenue Type Category	RevenueTypeCategory
Revenue ID	_revenueId_l	Text		Revenue Id	RevnId
Root Asset Key	rootAssetKey_l	Text		External Root Asset Key	ExternalRootAssetKey
Sales Channel	salesChannel_l	Menu		Sales Channel	SalesChannelCd
Subscription Id	subscriptionId_l	Text		Subscription Id	SubscriptionId
Subscription Line Id	subscriptionLineId_l	Text		Subscription Line Id	SubscriptionLineId

Note: The model_name attribute only retains the Oracle Sales mapping at the time of import. Once configuration and quoting take place it may be overwritten with the Oracle CPQ product information.

REST Import Opportunity

This integration updates the "Last Synchronized" date for an Oracle Sales quote and sales order header object to trigger upsert of opportunity revenue lines.

Type: REST - Import
Timeout: 100000
ID Field: transaction.opportunityNumber_t
Endpoint URL: /crmRestApi/resources/11.13.18.05/opportunities/{optyNumber}
MetaData URL: /crmRestApi/resources/11.13.18.05/opportunities/describe
Document: Main Document

Response Mapping

CPQ Attribute			Mapping	Oracle Sales Attribute
Name	Variable Name	Type	Mapping	Display Name	Variable Name
Business Unit ID	businessUnitId_t	Text		Business Unit ID	PrimaryOrganizationId
Contact Email Address	contactEmailAddress_t	Text		Primary Contact Email	PrimaryContactEmailAddress
Contact Name	contactName_t	Text		Primary Contact	PrimaryContactPartyName
Contact Party Number	_transaction_s_contactPartyName_t	Text		Primary Contact Party Number	PrimaryContactPartyNumber
Opportunity Amount	opportunityAmount_t	Currency		Amount	Amount_c
Opportunity ID	opportunityID_t	Text		Opportunity ID	OptyId
Opportunity Name	opportunityName_t	Text		Name	Name
Opportunity Win Probability	opportunityWinProbability_t	Integer		Win Probability	WinProb
Owner Resource Party ID	oRCL_SFA_OwnerResourcePartyID_t	Text		Owner	OwnerResourcePartyId
Primary Org ID	oRCL_SFA_PrimaryOrgID_t	Text		Business Unit ID	Primary OragnizationId
Revenue Category	_transaction_revenueCategory_t	Menu		Opportunity Type	OpportunityTypeCode

REST Line Sync Complete

This integration exports transaction level data from CPQ to the Oracle Sales quote and sales order header object.

Type: REST - Export
Timeout: 20000
ID Field: transaction.none
Endpoint URL: /crmRestApi/resources/11.13.18.05/salesOrders
MetaData URL: /crmRestApi/resources/11.13.18.05/salesOrders/describe
Document: Main Document