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 DECEMBER 04, 2019

Applies to:

Goal

Scenario:

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?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.