Why Are Adjustment Records Rounding Differently in AR Interface Table RA_INTERFACE_LINES_ALL Than Shown in OE_PRICE_ADJUSTMENTS?
(Doc ID 1542786.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Order Management - Version 11.5.10.0 and laterInformation in this document applies to any platform.
Goal
Qn1::From oe_price_adjustments data dump for sales order shows:
| LIST_LINE_TYPE_CODE | OPERAND | ADJUSTED_AMOUNT |
|---|---|---|
|
SUR |
-0.08500 | -0.08500 |
| SUR | 0.70000 | 0.70000 |
| SUR | 2.91000 | 2.91000 |
From the RA_INTERFACE_LINES_ALL for this sales order it shows:
| AMOUNT | QUANTITY_ORDERED | UNIT_SELLING_PRICE | UNIT_STANDARD_PRICE |
|---|---|---|---|
| -14.7100000 | 173 | -0.0850000 | -0.0850000 |
| 121.1100000 | 173 | 0.7000578 | 0.7000000 |
| 503.4300000 | 173 | 2.9100000 | 2.9100000 |
When the ra_interface_lines_all records are being created what is Oracle Order Management
doing to get the unit_selling_price which in this case is different than the unit_standard_price?
Why does unit_selling_price ( 0.7000578) not equal unit_standard_price (0.7000000)?
Where did amount = 121.11 come from?
Where did unit_selling_price = 0.7000578 come from?
How are these being populated?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |