My Oracle Support Banner

Unable to Update End Date of Price List Line "The effective dates for a price list line overlap with another line having effective start date" (Doc ID 2121055.1)

Last updated on JUNE 21, 2023

Applies to:

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

Symptoms

Problem Statement
When attempting to update end date of existing price list lines
from standard price list form, then the following error occurs.

Error
The price list line effectivity dates overlap with another
line having effective start date = (blank) and end date =
(blank). Within a price list, two lines with matching
product, UOM, and pricing attributes cannot have overlapping
effectivity dates.

Internal Name : QP_DUPLICATE_LIST_LINES_DATES


Steps to Reproduce

1. Navigate to: Price List Setup form
2. Query price list
3. Try to update end date of existing price list lines



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
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.