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 MARCH 08, 2017

Applies to:

Oracle Order Management - Version 11.5.10.0 and later
Information in this document applies to any platform.

Goal

Qn1::From oe_price_adjustments data dump for sales order shows:

 

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

 

AMOUNTQUANTITY_ORDEREDUNIT_SELLING_PRICEUNIT_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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms