Unable to Update an Existing Pricing Attribute

(Doc ID 2275482.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Price List

Unable to update an existing pricing attribute due error

It appears that there are Pricing Attribute orphan records in Price List Lines

 
ERROR
-----------------------

The effective dates for a price list line overlap with another line having effective start date = (blank) 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. via Oracle Pricing Manager
2. navigate to the price list setup form
3. query a price list and find a particular price list line
4. click on pricing attributes and attempt to change the pricing attribute to a different value

 

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