Volume Offer Error - Products And Categories Cannot Be Duplicate Within Or Across Discount Rule

(Doc ID 2148293.1)

Last updated on JUNE 13, 2017

Applies to:

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


On : 12.1.3 version, Offers

When updating existing lines in the product table,the following error message occurs :-


Private API: Create_Offer_Adjustmentstart
Private API: Validate_Offer_Adjustment
Inside Uk_Items::Create
check_Offer_Adj_Uk_Items :: l_dup_effective_dt
Private API: Validate_dm_model_rec
Private API: Validate_Offer_Adjustmentstart
Private API: Validate_Offer_Adjustmentend
Private API: Calling create table handler
Private API: Create_Offer_Adjustmentend
Private API: Create_Offer_Adj_Tierstart
Private API: Validate_Offer_Adj_Tier
OfferDiscountLineId is : 2
Private API: Validate_dm_model_rec
Private API: Validate_Offer_Adj_Tierstart
Private API: Validate_Offer_Adj_Tierend
Private API: Calling create table handler
Private API: Create_Offer_Adj_Tierend
OfferType is :VOLUME_OFFER
Products and categories cannot be duplicate within or across discount rules.

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

Accrual Budget is Active

Accrual Parameter Details > Adjustment
No previous adjustments created – this will be the first adjustment

Date 06-Aug-2015 to 22-Dec 2015

Click Create
Below are the existing offer details for the accrual budget
Please take note of the products section

Create Adjustment with Effective Date from today
Discount Table remains the same percentage
Products – the two item categories, de-select the ‘include volume’ flag
Click Update
Error occurs :Products and Categories cannot be duplicate within or across discount rules




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