Range and Block Pricing When Using Usd to Non Usd Multi Currency Conversions, on The Pricing and Availability Form (OEXPRAVA): ORA-06502 PL/SQL Numeric Or Value Error, ORA-01403
(Doc ID 2608022.1)
Last updated on JANUARY 25, 2021
Applies to:Oracle Order Management - Version 12.2.7 and later
Information in this document applies to any platform.
When attempting Range and Block pricing when using USD to Non USD multi currency conversions, the following error occurs on the Pricing and Availability form when trying to find the price of the item.
Exception :-6502 ORA-06502: PL/SQL: numeric or value error
ORA-01403: no data found
1. Via the Order Management Responsibility.
2. Navigate: Pricing & Availability.
3. Attempt to query a specific Item.
4. Click on the 'Price and Availability' button.
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