Quote pricing calculations produce incorrect totals due to custom rounding precision in CPQ

CRM Oracle CX Cloud
, , , , , , , ,
1

Our CPQ implementation is generating quotes with incorrect total amounts due to rounding issues in the custom pricing calculation engine. We’ve configured complex pricing rules that include volume discounts, promotional pricing, and multi-tier margin calculations. The individual line items calculate correctly, but when the quote totals are computed, we’re seeing discrepancies of $0.01 to $0.50 on large quotes.

The problem appears to be related to decimal precision handling. Our pricing rules use 4 decimal places for unit prices (e.g., $123.4567), but the quote total rounds to 2 decimals. This causes accumulating rounding errors across multiple line items.

Here’s a sample calculation showing the issue:


Line 1: 100 units × $10.2567 = $1,025.67
Line 2: 50 units × $20.5134 = $1,025.67
Expected Total: $2,051.34
Actual Total: $2,051.33

We’ve checked the Configure Price Quote settings but can’t find where to adjust the rounding precision for the calculation engine. The price validation rules are also flagging these discrepancies as errors, blocking quote approvals. How do we configure proper decimal handling and rounding precision in Oracle CPQ to ensure accurate quote totals?

2

Also consider the database column precision for price fields. If your custom price attributes are defined with insufficient decimal precision at the database level, the calculation engine’s precision settings won’t help. Check Application Composer to verify that all custom price fields are defined as Number type with appropriate scale (e.g., Number(18,6) for 6 decimal places). Mismatched precision between the calculation engine and database storage causes data truncation.