ITEM and UOM not on PRICELIST and QP: Qualify Secondary Price Lists = No
(Doc ID 1679273.1)
Last updated on NOVEMBER 21, 2018
Oracle Advanced Pricing - Version 12.1.3 and later Information in this document applies to any platform.
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".
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!