ITEM and UOM not on PRICELIST and QP: Qualify Secondary Price Lists = No

(Doc ID 1679273.1)

Last updated on MARCH 08, 2017

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, Pricing Engine

QP: Qualify Secondary Price Lists = No.

Qualifiers are on secondary price list.
No qualifiers on primary price list.
No items are on the price list meaning there are no price list lines on the primary price list.

When enter an order with primary price list and an item on the secondary
price list, item should price from secondary price list.
Instead, receiving error:
Price was not found on price list IT_SECON_TEST1_OE for this item IT_FG1 and
uom EA.

As the item is on the secondary price list, expect the item to price; no error.

ERROR
-----------------------
Price was not found on price list IT_SECON_TEST1_OE for this item IT_FG1 and
uom EA.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup the profile option "QP: Qualify Secondary Price Lists" value to "No".
2. In our pricing design, we are using Secondary price lists extensively. Primary price list is created without any Item or price value. Secondary Price lists are added with proper precedence. Secondary Price lists have item & Price values.
3. Added Qualifiers to secondary price lists. Ideally qualifiers should be ignored because profile option "QP: Qualify Secondary Price Lists" is set to No.
4. Entered a sales order line fetched the correct price, BUT while saving getting an error message saying "ITEM & UOM not on in PRICE LIST".


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