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 |
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 Format:
|
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 |