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

Last updated on FEBRUARY 14, 2017

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

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