Error Messages on Transact Move Order Form ORA-06502 (Doc ID 1179064.1)

Last updated on AUGUST 02, 2016

Applies to:

Oracle Inventory Management - Version 12.1.1 and later
Information in this document applies to any platform.
Currency check on Mar.01/2015

Symptoms

On version 12.1.1 , when attempting to Ship Confirm Sales Order Lines containing Lots with varying Primary Quantities, the following error occurs:

ERROR
-----------------------
"The quantity entered is lower than the allowed deviation for the item."

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Release Sales Order for Picking
2. After Sales Order Allocation by pick release, Transact Move Order->View Allocation.>Select Available inventory
3. Made the first lot qty 0, as it’s not required
4. Clicked Done on ‘Select Available Inventory’ form
5. Clicking Transact Button first time: ‘Lot and/or Serial Number quantity does not match transaction quantity’
6. On Clicking Transact Button second time, it’s different error
‘ORA-06502: PL/SQL: numeric or value error: character to number conversion error in Package INV_MO_LINE_DETAIL_UTIL’
Procedure ARE_ALLOCATIONS_COMPLETE

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