Pricing And Availability: Error Price Was Not Found On Price List For This Item And UOm When Using A Custom Qualifier Defined Using Transactional Currency Code ( oe_order_pub.g_hdr.transactional_curr_code) (Doc ID 1459196.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
OEXPRAVA.fmx

Symptoms

On : 12.1.3 version, Quoting & Negotiation

When attempting to use the Pricing and Availability window the following error is shown:

Error: Price was not found on price list for this item and uom pops up while the price and availability is queried using item, uom, currency or using item, uom, price list, currency and no price is displayed,
the following error occurs.

ERROR
-----------------------
Note
Error: Price was not found on price list for this item
0003378 and uom EA.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Navigate Order Management Super User: Pricing and Availability
Pricing and Availability window opens
Enter Item 0003378 Currency USD and press [Price and Availability] button; Error Note pops up
Note
Error: Price was not found on price list for this item
0003378 and uom EA.

Enter Item 0003378 Price List 2012 CAD Currency CAD and press [Price and Availability] button: Same Error Note pops up
Note
Error: Price was not found on price list for this item
0003378 and uom EA.

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