R12.2 Misc Receipt Change Secondary Qty Error with FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-06502

(Doc ID 1910882.1)

Last updated on MAY 28, 2017

Applies to:

Oracle Inventory Management - Version 12.2.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.2 version, Onhand and Availability

When attempting to perform Misc. receipt, the following error occurs.

ERROR
-----------------------
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-06502

 

Reproduce Steps

--------------------

In Responsibility 'XXX Warehouse Super User':
1. Define a new ITEM
Unit of Measure:
Primary : Pieces, Tracking : Primary & Secondary, Pricing : Primary, Secondary: Master Pack, Defaulting : Default
Deviation Factor + : 50%, Deviation Factor - 50%
Conversions : Item specific
This item is copied from @Purchased Item

2. Material Setup > Units of Measure > Conversions > Intra Class:

<ITEM> Master Pack Content = 30 * Pieces

3. Do misc receipt
- Enter the item, primary UOM is defaulted, enter '40' as the primary quantity, secondary quantity is auto populated as 1.33333 .
- Manually change secondary quantity from 1.33333 to be as 1
- Got Decision Dialogue with message :
Apply Converted quantity to primary quantity?
- Choose to click 'No'
- Got error message at form bottom:
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-06502
- Then end user cannot proceed with the transaction forward after choose 'No'


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