My Oracle Support Banner

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

Last updated on OCTOBER 26, 2021

Applies to:

Oracle Trade Management - Version 12.2.6 and later
Information in this document applies to any platform.

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

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.