My Oracle Support Banner

Pick Selection List Generation - SRS - Completing In Error Due To Corrupt Reservation (Doc ID 2778390.1)

Last updated on JUNE 21, 2023

Applies to:

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

Symptoms

Pick release fails with below error

Error
Error occurred in Inv_Pick_Release_Pub.Pick_Release
SQLCODE: -6502 SQLERRM: ORA-06502: PL/SQL: numeric or value error
Exception occurred in WSH_PICK_LIST.Release_Batch_Sub
  Unexpected error has occured. Oracle error message is ORA-06502: PL/SQL: numeric or value error


Steps
1. Create Sales Order and book it.
2. Pick Release the order.
  Error occurs.


 

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.