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 JANUARY 27, 2020

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


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


STEPS

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



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.