Error While Activating Adjustment On Volume Offer With Decimal Tier Qty

(Doc ID 2315159.1)

Last updated on OCTOBER 09, 2017

Applies to:

Oracle Trade Management - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Offers

Getting an error while creating Activating Adjustments on a Volume Offer which has Tiered Levels with Decimal Values.  If users don't use decimal Values, then Adjustments are working fine.


ERROR
-----------------------

I. 
p_modifier_line_tbl.COUNT
2.
GR Updated header date:S
3.
In process_old_discounts: Offer Adj Id: 12001
4.
In process_old_discounts: Offer Type = VOLUME_OFFER
5.
In process_old_discounts: Call to adjust_old_discounts for VO = Y
6.
Calling adjust_old_discounts for VO
7.
Private API: Update_vo_discountstart
8.
Private API: Validate_vo_discounts
9.
Private API: Validate_vo_discountsstart
10.
Private API: Validate_vo_discountsRetum status is: S
11.
Private API: Check vo_discount Itemsstart
12.
Private API: check_vo_discounts_req_itemsstart
13.
Private API: check_vo_req jtemsstart
14.
Offer Type is VOLUME_OFFEROffer Id is :22003
15.
Private API: check_dis_req_ffemsstart
16.
Private API: check_dis_req_itemsend
17.
Private API: check_vo_req_itemsend
18.
Private API: check_vo_discounts_req_itemsend
19.
Parent Id is :14002
20.
uom is
21.
Private API: Check vo_discount_ltemsend
22.
Private API: Validate_vo_discountsRetum status is: S
23.
Private API: Validate_vo_discountsend
24.
Private API: Update vo_discountend
25.
Private API: Create_vo_discountstart
26.
disc struct id is :3761
27.
Calling Validate Discounts: Return Status is :S
28.
Private API: Validate_vo_discountsstart
29.
Private API: Validate_vo_discountsRetum status is: S
30.
Private API: Check vo_discount_ltemsstart
31.
Private API: check_vo_discounts_req_itemsstart
32.
Private API: check_vo_req_itemsstart
33.
Offer Type is VOLUME_OFFEROffer Id is :22003
34.
Private API: check_dis_req_itemsstart
35.
Private API: check_dis_req_itemsend
36.
Private API: check_vo_req_itemsend
37.
Private API: check_vo_discounts_req_itemsend
38.
Parent Id is :14002
39.
uom is
40.
Discount is :0
41.
Private API: Check vo_discount Itemsend
42.
Private API: Validate_vo_discountsRetum status is: S
43.
Private API: Validate_vo_discountsend
44.
Private API: Calling create table handler
45.
Private API: Create_vo_discountend
46.
x_retum_status of update_vo_tiersS
47.
calling update_old_products
48.
in update_old_products
49.
I_AdjProd.activity_fiagM
50.
I_AdjProd.activity_fiagM
51.
x_retum_status of update_old_productsS
52.
calling create_new_qp_lines
53.
populate_pbh_line pbh_pricing_attr_tbl.count1
54.
c_discountLines Loop i:1
55.
LdiscountLinesto_rltd_modifier id :2635861
56.
populate_dis_lines merge_pricing_attributes x_pricing_attr_lbl countl
57.
x_pricing_attr_tbl(k).pricing_attr_value_from.99
58.
x_pricing_attr_tbl(k).pricing_attr_value_to4.99
59.
x_pricing_attr_tbl(k).pricing_attr_value_from.99
60.
x_pricing_attr_tbl(k).pricing_attr_value_to4.99
61.
c_discountLines Loop i:2
62.
l_discountLines.to_rltd_modifier id :2635859
63.
populate_dis_lines merge_pricing_attributes x_pricing_attr_lbl count2
64.
x_pricing_attr_tbl(k).pricing_attr_value_from.99
65.
x_pricing_attr_tbl(k).pricing_attr_value_to4.99
66.
x_pricing_attr_tbl(k).pricing_attr_value_from4.99
67.
x_pricing_attr_tbl(k).pricing_attr_value_to1000
68.
x_pricing_attr_tbl(k).pricing_attr_value_from4.99
69.
x_pricing_affr_tbl(k).pricing_attr_value_to1000
70.
populate_pbh_line dis_pricing_attr tblcount2
71.
populate_modifier lines merge_pricing_attributes l_pricingAttrTbl.count3
72.
process_modifiers x_msg_data :QPG_MISS_CHAROP_NON_ZERO_BREAK_VALUEG_MISS_CHAR
73.
process_modifiers x_retum_status :E
74.
Adjust_old_discounts Status: E
O

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a volume offer with decimal tiers and activated.
2. Create an adjustment and backdate it.
3. Activate the adjustment Error message appears.


Changes

 

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