System Is Not Restricting While Creating Duplicate Entries In the Price List (Doc ID 2160487.1)

Last updated on OCTOBER 05, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Price List

System is not restricting while creating duplicate entries in Pricelist
Recently upgraded application from 11i. In R12 and can see the system
is not restricting the user from creating duplicate entries in price lists.


ERROR
-----------------------
Note
The effective dates for the price list line overlap with
another line having effective start date - 11-JAN-16 and end
date = (blank). Within a price list, two price list lines
with matching product, UOM, and pricing attributes cannot
have overlapping effective dates.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Oracle Pricing Manager
2. Price Lists/Price List Setup
3. Query the Item “126507” in the price list “ABC Base Price”
This Item has only one line in the price list
4. Press “SHIFT+F6”, the first line gets copied to the next line. Change the Item code to “118778” and change the price and save.
Upon saving, system throws an error with Overlap in effectivity Date.

Note
The effective dates for the price list line overlap with
another line having effective start date - 11-JAN-16 and end
date = (blank). Within a price list, two price list lines
with matching product, UOM, and pricing attributes cannot
have overlapping effective dates.

5. Press the delete button. Save the Close the form
6. Query the Item “118778”.
Now it shows two rows with same effectivity date.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users can create duplicate price list lines.

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