Component Product Promotion Pricing Does Not Accept Decimal Amount Or Percent

(Doc ID 1672139.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel eCommunications - Version 8.1.1.11 [23030] and later
Information in this document applies to any platform.
1. S_PRO_CFG_ITEM.ADJ_VAL_AMT column:
In Pricing, this is known as the "adjustment value amount", which may be a set discount price, or a percentage discount.
For example:
A. When used as a set amount:
The list price of an item may be $10, and could be used in this manner to change the item price for the customer:
If the value of Adjustment Type (PRO_ADJ_TYPE_CD) = “Price Override”,
and the Adjustment Value (ADJ_VAL_AMT) = 6,
then the customer price of the item will be changed to $6.

B. When used as a discount percentage (scalar/precision value up to 7 digits behind the decimal)
The list price of an item may be $10, and could be used in this manner to change the item price for the customer:
If the value of Adjustment Type (PRO_ADJ_TYPE_CD) = “Price Override”,
and the Adjustment Value (ADJ_VAL_AMT) = .50,
then the customer price of the item will be changed to $5

2. S_PRO_CFG_ITEM.MAX_PRI column:
In Pricing, this is the maximum applicable price for the item, (the price cannot exceed this amount).

Symptoms

The price of the promotion components are rounded.

1- Go to Screen Administration - Product
2- Go to view Product Promotions and select the desired promotion
3- Go to view Pricing then components and drill down the customization product or create new if it's not already defined.
4- Select on of the components from the "Pricing Designer" applet.
5- Go to "Adjustments" applet and press the New button
6- Set the Adjustment Type = "Price Override" and set the Adjustment Value = 4.5 and save the record
7- Re-Query the created record and the Adjustment Price is now 5 and this is a wrong behavior

Cause

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