ORA-06502: PL/SQL: Numeric Or Value Error: Character To Number Conversion Error While Importing

(Doc ID 1911717.1)

Last updated on JUNE 06, 2017

Applies to:

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

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 CC:GI:XSizi3806
 
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 : 431460
Source publication : 81615 target publication:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms