My Oracle Support Banner

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 NOVEMBER 05, 2019

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

Symptoms

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.

 

ERROR

THE STATUSIPL:Price was not found on price list for this item xxxxxxx and uom YY.
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.

 

NOTES
Issue occurs for two different scenarios:

- SCENARIO 1 - attempt to add an order line to an existing booked order
   Debug log shows: 

  

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
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.