WIP Mass Load Does Not Update Sub Inventory And Location And Gives ORA-06502 Errors
(Doc ID 2246523.1)
Last updated on FEBRUARY 10, 2021
Applies to:Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to update the sub inventory and location for job components that have a WIP Supply Type of Phantom on the Bill Of Material
the following error occurs;
Error from the pending job and schedule
Error Type Error Message
Error WIPJDLDB load all details ORA-06502: PL/SQL: numeric or value error: character to number conversion error
The issue can be reproduced at will with the following steps:
1. Update WIP_JOB_SCHEDULE_Interface and WIP_JOB_DTL_INTERFACE tables with jobs to be updated
2. Run mass load
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