My Oracle Support Banner

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

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.