My Oracle Support Banner

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 JUNE 13, 2018

Applies to:

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


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




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


-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?


To view full details, 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 a vibrant support community of peers and Oracle experts.