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

Applies to:

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

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

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