Appendix C: Understand the OIC Integration Mappings

You must be able to understand the variable mappings for each integration as a requirement to complete the Sync Quote action in Oracle Configure, Price, Quote.

Importing and setting up the OIC package is a prerequisite to completing the Sync Quote action in Oracle Configure, Price, Quote.

After all Oracle Configure, Price, Quote setup is completed, regenerate the OIC integration flows to ensure they accurately reflect the current state of the Oracle Quote to Order Commerce process.

Note: Mappings in bold indicate complex, conditional mappings. Mappings in italics indicate the mappings are a static text value instead of a source attribute.

Integration Flow	Target Variable Name	Mapping	Comments
OCCS-CPQ Create Quote > New_Transaction		-	None
-	cC_RequesterNote_t	requesterNote	None
-	cC_OrgId_t	organizationId	None
-	cC_OrderId_t	id	None
-	cC_SiteId_t	siteId	None
-	cC_RequesterNote_t	requesterNote	None
-	currencyCode	currencyCode	None
-	_customer_t_address	shippingGroups >address1	None
-	_customer_t_state	shippingGroups > state	None
-	_customer_t_address_2	shippingGroups > address2	None
-	_customer_t_company_name	shippingGroups > companyName	None
-	_customer_t_country	shippingGroups > country	None
-	_customer_t_city	shippingGroups > city	None
-	_customer_t_zip	shippingGroups > postalCode	None
-	_customer_t_phone	shippingGroups > phoneNumber	None
-	_customer_t_email	email	None
-	_customer_t_last_name	lastName	None
-	_customer_t_first_name	firstName	None
-	items	commerceItems	None
-	_price_book_var_name	_default_price_book	None
-	_configuration_id	configuratorId	None
-	cC_CommerceItemId_l	id	None
-	_part_number	catalogRefId	None
-	cC_CatalogRefId_l	catalogRefId	None
-	_price_quantity	quantity	None
-	cC_ProductId_l	productId	None
-	cC_NetPrice_l > value	priceInfo > amount > quantity	None
-	cC_NetPrice_l > currency	priceInfo > currencyCode	None
-	_modify_action	cleanSave_t	None
OCCS-CPQ Create Quote > Update_Quote		-	None
-	id	id	None
-	externalId	bs_id	None
OCCS-CPQ Create Quote > Re-Request_Quote		-	None
-	cC_RequesterNote_t	requesterNote	None
-	id	externalId	None
OCCS-CPQ Sync Quote	-	-	None
-	id	cC_OrderId_t	None
-	providerNote	cC_ProviderNote_t	None
-	agentId	cC_AgentId_t	None
-	externalId	id	None
-	expirationDate	cC_ExpirationDate_t	None
-	externalPrice	totalOneTimeNetAmount_t	None
line-item	-	-	None
-	productId	cC_ProductId_l	None
-	catalogRefId	cC_CatalogRefId_l	None
-	configuratorId	_configuration_id	None
-	externalPrice	netPrice_l	None
-	externalPriceQuantity	-1	None
-	id	cC_CommerceItemId_l	None
-	actionCode	oRCL_ABO_ActionCode_l	None
-	quantity	requestedQuantity_l	None
-	externalData	configattrinfo	XSL manipulations to feed config attributes as an array of maps. Format: <externalData> <name></name> <values> <name></name> <variableName></variableName> <label>Id</label> <displayValue></displayValue> <value></value> </values> </externalData> < externalData> <name></name> <values> <name></name> <variableName></variableName> <label></label> <displayValue></displayValue> <value></value> </values> </ externalData>
OCCS-CPQ Update Quote > Accept Quote		-	None
-	id	externalId	None
-	cC_AgentId_t	agentId	None
OCCS-CPQ Update Quote > Reject Quote		-	None
-	id	externalId	None
-	cC_AgentId_t	agentId	None
-	cC_RejectionDate_t	date	None
-	rejectExplanation_t	note	None
OCCS-CPQ Update Quote > Cancel Quote		-	None
-	id	externalId	None
-	cC_AgentId_t	agentId	None
-	cC_RejectionDate_t	date	None
-	rejectExplanation_t	note	None
OCCS-CPQ Get Configurations		-	None
-	locale	locale	None
-	currency	currencyCode	None
-	configurationId	configuratorId	None
-	price	true	None
-	spare	true	None
-	bomMapping	true	None
OCCS-CPQ Get Assets
-	limit	limit	None
-	offset	offset	None
-	q	for-each(id), for-each(id), for-each(recordId), "{$and:[{$or:[", "{id:{$eq: "", recordId, ""}}", ""}},", "]}", ",", "{$and:[", "{$or:[", "{customer:{$eq:"", id, ""}}", ""}},", "]}", ",", "{$or:[", "{serviceAccount:{$eq:"", id, ""}}", ""}},", "]}", "]}"	None
-	expand	descendantAssets	None
OCCS-CPQ Asset Actions (for all flows)
-	id	recordId	None
-	sourceIdentifier	sourceIdentifier	None
-	transactionDate	transactionDate	None
-	transactionId	transactionId	None
OCCS-CPQ Asset Actions (CpqModifyAsset flow)
-	productLine	product_line	None
-	configContextKey	configContextKey	None
-	configuratorUrl	configuratorURL	None
-	bomKey	bomkey	None
-	segment	segment	None
-	model	model	None
OCCS-CPQ Asset Actions (CpqRenewAsset, CpqTerminateAsset, CpqSuspendAsset, CpqResumeAsset flows)
-	configId	lineId	None
-	serviceAccountId	serviceAccount	None
-	deactivationDate	endDate	None
-	amount	amount	None
-	quantity	quantity	None
-	parentServiceId	parentId	None
-	externalRecurringCharge	field5	Corresponds to part custom field 5 in Oracle CPQ
-	externalData	attributes	None
-	billingAccountId	billingAccount	None
-	externalRecurringChargeFrequency	field4	Corresponds to part custom field 4 in Oracle Configure, Price, Quote
-	childItems	for-each(children), for-each(partNumber)	None
-	catalogRefId	partNumber	None
-	configuratorId	lineId	None
-	externalRecurringDuration	field6	Corresponds to part custom field 6 in Oracle Configure, Price, Quote
-	externalPrice	_price_unit_price_each	None
-	assetId	id	None
-	actionCode	oRCL_ABO_ActionCode_l	None
-	serviceId	id	None
-	activationDate	startDate	None