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