ORA-06502: PL/SQL: Numeric Or Value Error: Character To Number Conversion Error While Importing (Doc ID 1911717.1)

Last updated on OCTOBER 09, 2023

Applies to:

Symptoms

Issue Clarification:
--------------------
On Configurator Build 12.1.3.31.7 , attempting to import non-BOM models using standard import process provided by oracle using cz_imp_xxxx tables.
This Non-BOM model is imported into Configurator with some conventional value in orig_sys_ref field, example of it is like AB:CD:EFizi1234
 
After importing Non-BOM model, this Non-BOM model is added as a referenced model under an existing BOM Model. When publishing this BOM model to target instance, it is failing in publication.  It seems to try to parse inventory item id and org id and failing.
 
Error Message:
-------------

BOM Synchronization, version 120.9.12010000.10, started 2014/06/16/13:51:06, session run ID: 68076
Fatal publication error when using BULK COLLECT on table ''cz_ps_nodes'': ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPS.CZ_BOM_SYNCH", line 2054
Fatal error occured during data upload
Fatal publication error, process aborted for publication 81615: Fatal error reported
Fatal publication error, process aborted for publication 81615: Fatal error reported
Parent model in publication (migration) request : XXXXX
Source publication : xxxxx target publication:

Cause

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