My Oracle Support Banner

Previous Net Price Field In Order Entry Line Items Is Rounding Off Decimal Number (Doc ID 2507011.1)

Last updated on NOVEMBER 19, 2019

Applies to:

Siebel CRM - Version 16.13 [IP2016] and later
Information 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


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