My Oracle Support Banner

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:

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
 Scenario:
 
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
 Answer 1) Yes, these would be the fields that one would check for reporting.
Answer 2) In Pricing, one can opt to setup the modifier with a positive or negative value.  It is not restricted by type of modifier (ie: discount, surcharge, etc).
Answer 3) See below:
References


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