My Oracle Support Banner

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

Last updated on APRIL 04, 2022

Applies to:

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


Issue Clarification:
On Configurator Build , 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:


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.