My Oracle Support Banner

Item Was Added To Price List But Unable To See The Item In Price List (Doc ID 2206426.1)

Last updated on MARCH 10, 2023

Applies to:

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

Symptoms

A new item was added to the price list but is no longer visible in the Price List.
When trying to add it again an error message appears:

ERROR

The effective dates for a price list line overlap with another line having
effective start date = 01-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 TO REPRODUCE THE ISSUE
1. Oracle Pricing Manager Responsibility
2. Navigate To: Price List > Price List Setup
3. Query the price list name = <price list name>
4. Add item <item name> to price list.
5. Re-query price list
6. Item is no longer shown in the price list
7. If you try to add the item again, you receive the error message above.


When running "QP: Maintains the denormalized data in QP Qualifiers", following error appears in the log file:

ERROR

Begin Update Pricing Phases -  update_type ALL
Begin Pricing Phase Update
EXCEPTION RAISED IN PHASE UPDATEORA-01502: index 'QP.QP_LIST_LINES_N4' or
partition of such index is in unusable state

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.