Error While Activating The Offer Adjustment - Duplicate Qualifiers Exist. (Doc ID 2817103.1)

Last updated on JANUARY 25, 2023

Applies to:

Symptoms

On : 12.2.6 version, Offers

Error While Activating The Offer Adjustment from front end screen


Problem Description
-----------------------------
When trying to make the offer Adjustment from front end screen, getting an error Duplicate qualifiers exist.

Error details -
---------------------------
5623.List Header Id : 1378580 List Line Id: -1 Group Number: 1530
5624.Beneficiary ID:
5625.Beneficiary ID:
5626.process_new_qualifiers: offerAdjustmentId: 251051
5627.l_qualifiers.activity_flag:U
5628.l_qualifiers.qualifier_context:CUSTOMER_GROUP
5629.end dating existing qualifiers
5630.value of l_qualifiers_tbl(i).qualifier_datatype beforeG_MISS_CHAR
5631.value of l_qualifiers_tbl(i).qualifier_datatype afterC
5632.Duplicate qualifiers exist. (Qualifier Grouping No.: 1530, Context: Customer Group, Attribute: ChRM Consolidation Group-GEA)

-





STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1.(R) Oracle Trade Management User
2.(N)Trade Planning -->Create an accrual offer with three product lines.
3.Make the offer active.
4.Create an adjustment and enter 10 product and 10 qualifier lines.
5.End date 3 lines in qualifier.
6.Activate the adjustment.
7.Activation should happen successfully without any errors.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot activate Offer adjustment.

Changes

Cause

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