My Oracle Support Banner

WIP ECC Data Load Fails On Wip-wodetail Data Set (Doc ID 2876348.1)

Last updated on JUNE 10, 2022

Applies to:

Oracle Work in Process - Version 12.2.7 and later
All Platforms


When submitting the WIP ECC data load (Discrete Manufacturing), the process fails on the wip-wodetail data set. WIP ECC Data load log shows the following error.


There is SQLException while applying load rule for dataset wip-wodetails for job 31,046. Exception details ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APPS.FND_NUMBER", line 20 oracle.jdbc.driver.T4CTTIoer11.processError( oracle.jdbc.driver.T4CTTIoer11.processError( oracle.jdbc.driver.T4C8Oall.processError( oracle.jdbc.driver.T4CTTIfun.receive(


The issue can be reproduced at will with the following steps:
1. Log in to Manufacturing and Distribution Manager Responsibility.
2. Go to Requests screen.
3. Submit WIP ECC Data Load Program.
4. Full Load completes with error.
5. In ECC Developer, user can review more specifics about which data set has failures(iewip-wodetails).




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.