My Oracle Support Banner

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 MARCH 26, 2018

Applies to:

Oracle Depot Repair - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3Repair Order Management

When attempting to complete a WIP job the following error occurs.

ERROR
-----------------------
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.


STEPS
-----------------------
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.

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.