My Oracle Support Banner

Incorrect Data In QP Modifier Created From Volume Offer In Trade Management (Doc ID 2757759.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Advanced Pricing - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, 

ACTUAL BEHAVIOR
---------------
For the Promotional Modifier created from Volume Offer in Trade management, when the original offer in trade management is modified and re-submitted for approval, the following issues occur. 


1) For end dated supplier lines in offer in Trade Management "Volume Offer Adjustment 1" , duplicate entries are created in QP Modifier "Volume Offer Adjustment 1" .

2) For those lines in QP Modifier "Volume Offer Adjustment 1" which are active, corresponding to each supplier, upon clicking on "Exclude" option, even the excluded brand of other supplier is getting fetched .


EXPECTED BEHAVIOR
-----------------------
For the Promotional Modifier created from Volume Offer in Trade management, when the original offer in trade management is modified and re-submitted for approval, following are the expectations

1) Duplicate entries are not fetched and created as Modifier Lines

2) Excluded brand of the supplier corresponding to modifier line alone is fetched.


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

1.  Customer creates a Volume Offer in Trade Management - Offer Name : "Volume Offer Adjustment 1"

2.  ABC and XYZ are 2 suppliers for which this offer is setup with below conditions
    1-10000 Discount = 1%
    10000-30000 Discount = 2%
    30000-99999999 Discount = 3%

3.  Initially Exclusion is setup for one brand of each supplier :

Supplier : ABC Excluded Brand : ABC Other
Supplier : XYZ Excluded Brand : XYZ Other

4. Offer is Approved – Modifier "Volume Offer Adjustment 1" is created in EBS in QP without any issues

5. User changes the excluded brand for each supplier ABC and XYZ in the above offer in Trade Management. Since there is no option to remove/delete the exclusion options for the suppliers ( ABC and XYZ ), customer end dates the above mentioned suppliers ABC and XYZ and re-creates the same suppliers ABC and XYZ in new lines

6.  User now sets up the exclusion for a different brand for each supplier

Supplier : ABC Excluded Brand : ABC |ISS
Supplier : XYZ Excluded Brand : XYZ  Education services

7.  Offer is Approved – Modifier "Volume Offer Adjustment 1" is also modified in EBS in QP

8. For the updated Modifier setup created , following issues are found

1) For end dated supplier lines in offer in Trade Management "Volume Offer Adjustment 1" , duplicate entries are created in QP Modifier "Volume Offer Adjustment 1" . Expectation is that duplicate entries are not fetched and created as Modifier Lines

2) For those lines in QP Modifier "Volume Offer Adjustment 1" which are active, corresponding to each supplier, upon clicking on "Exclude" option, even the excluded brand of other supplier is getting fetched . Expectation is that, excluded brand of the supplier corresponding to modifier line alone is fetched

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.