Error When Completing WIP Job From Depot Repair 'PL/SQL: Numeric Or Value Error In Package WIP_SO_RESERVATIONS'
(Doc ID 2378728.1)
Last updated on JULY 14, 2020
Applies to:Oracle Depot Repair - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3Repair Order Management
When attempting to complete a WIP job the following error occurs.
Transaction processor error ORA-06502: PL/SQL: numeric or value error in Package WIP_SO_RESERVATIONS Procedure ALLOCATE_COMPLETION_TO_SO
ORA-06502: PL/SQL: numeric or value error in Package WIP_SO_RESERVATIONS Procedure ALLOCATE_COMPLETION_TO_SO
Transaction processing for the selected job has failed.
The issue can be reproduced at will with the following steps:
1. Create a repair order
2. receive the item to be repaired.
3. Create WIP job in tech portal
4. Perform WIP completion in tech portal.. error occurs.
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