Why do Negative Line Charges In the Sales Order Form Not Show As Negative In The Underlying Database Tables?
(Doc ID 2242240.1)
Last updated on AUGUST 14, 2018
Applies to:Oracle Order Management - Version 12.0.4 and later
Information in this document applies to any platform.
Conducting a simple test where an automatic line-level freight modifier with include on return flag enabled,
is applied to a standard sales order. When this order is copied to a return order, both have a positive value
for operand in table oe_price_adjustments. To determine the sign (+/-), one would also want to check the
value of credit_or_charge_flag in table oe_price_adjustments.
This document will further explain the functionality by addressing the following questions.
Question 1) Would we suggest to key off those fields (operand and credit_or_charge_flag) for our reporting and other uses?
Question 2) Why do Negative Line Charges In the Sales Order Form Not Show As Negative In The Underlying Database Tables? Why is it behaving differently(out of curiosity alone)?
Question 3) The "credit_or_charge_flag" is D for positive, C for negative (Debit or Credit? correct?) What does null mean?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!