My Oracle Support Banner

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
3. Errors


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

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