Previous Net Price Field In Order Entry Line Items Is Rounding Off Decimal Number
(Doc ID 2507011.1)
Last updated on MAY 02, 2023
Applies to:
Siebel CRM - Version 16.13 [IP2016] and laterInformation in this document applies to any platform.
Symptoms
On : 16.13 [IP2016] version, Order Management
ACTUAL BEHAVIOR
---------------
Previous Net Price field in Order Entry Line Items is rounding off decimal number while Modifying the Order
When we are comparing with "Previous Net Price" with "Net Price" in our custom validation found that "Previous Net price" is truncating the decimal part and Net Price remaining same with decimal point.
For Example if value is 599.2 then Previous Net price stores 599 and in "Net Price" 599.2
We have a expression in our Dynamic Pricing workflow with Net price and Previous Net Price which is evaluating wrong results.
Found column PREV_NET_PRI is '0' in S_ORDER_ITEM_OM table and below is the .
Table: S_ORDER_ITEM_OM
Column: PREV_NET_PRI
SCALE: 0
Field: Previous Net Price
Type: DTYPE_CURRENCY
Table: S_ORDER_ITEM
Column: NET_PRI
SCALE: 7
Type: DTYPE_CURRENCY
Field: Net Price
Type: DTYPE_CURRENCY
What is the reason for Inconsistent Column defination in OOTB
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Validations does not work properly
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |