Cannot Get List Price When Line Is Added to a Booked Order or Line Split - ITEM and UOM Error
(Doc ID 1670979.1)
Last updated on SEPTEMBER 22, 2018
Applies to:Oracle Advanced Pricing - Version 12.2.3 and later
Oracle Order Management - Version 12.2.3 and later
Information in this document applies to any platform.
OEXOEORD - Sales order form
When attempting to add a sales order line to a booked order, if the price list is qualified based on Sales Channel or Customer Class, the following error occurs.
Error also occurs when splitting an existing line on a booked order.
THE STATUSIPL:NMS:Price was not found on price list for this item xxxxxxx and uom EA.
INVALID ITEM/PRICE LIST COMBINATION
STEPS TO REPRODUCE
1. Oracle Pricing Manager responsibility
2. Price Lists > Define
3. Create a price list with the qualifier of Customer Class
4. Order Management responsibility
5. Orders, Returns > Sales Order
6. Create a sales order and book it.
7. Attempt to add an item from the price list in step 2.
Issue occurs for two different scenarios:
- SCENARIO 1 - attempt to add an order line to an existing booked order
Debug log shows:
BEFORE CHECKING BOOK FLAG
EXCEPTION: PRICE LIST MISSING FOR BOOKED ORDER
- SCENARIO 2 - Upon splitting the line an error message is thrown:
*STATUS_TEXT:=Duplicate price list lines:VTBNL DEF PL, VTBNL DEF PL
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