Sales and Oracle CPQ Attributes Mapping to Sync Revenue Lines from Quote Lines

As the final step in setting up the reconciliation of revenue lines from quote lines, verify the mapping of Sales and Oracle CPQ attributes.

Here are the steps to verify the default mapping:

  1. In the Setup and Maintenance work area, use the Manage Oracle CX Sales to Oracle CPQ Cloud Integration task.
    • Offering: Sales
    • Functional Area: Integrations
    • Task: Manage Oracle CX Sales to Oracle CPQ Cloud Integration
  2. In the Manage Oracle CX Sales to Oracle CPQ Cloud Integration page, go to the Quote Line to Revenue Line Mapping tab.

  3. Verify that the default mapping of CX Sales and Oracle CPQ attributes is intact. Refer to the table here for the standard mapping:
    Revenue Attribute Name (CX Sales) Quote Lines Attribute Name (Oracle CPQ)
    InventoryOrgId InventoryOrgId
    InventoryItemId InventoryItemId
    UnitPrice UnitListPrice
    Discount DiscountPercentage
    Quantity Quantity
    UOMCode UOMCode
    NonRecurringRevenue NonRecurringRevenue
    RecurringRevenue RecurringRevenue
    UsageRevenue UsageRevenue
    RevnAmount ContractValue
    MonthlyRecurringRevenue MonthlyRecurringRevenue
    MonthlyUsageRevenue MonthlyUsageRevenue
    ContractStartDate ContractStartDate
    ContractEndDate ContractEndDate
    RecurStartDate ContractStartDate
    RecurEndDate ContractEndDate
    RevnAmountCurcyCode CurrencyCode
    RecurFrequencyCode PricePeriodCode
    RecurNumberPeriods ContractPeriods
  4. If you've made any changes, save them.
  5. Sign in again for the changes to take effect.