My Oracle Support Banner

[V5] Enterprise Asset Management Command Center Data Load Fails with ORA-06502/ORA-06512 at "APPS.EAM_ECC_ASSETS_UTIL_PVT" (Doc ID 2727234.1)

Last updated on JULY 09, 2021

Applies to:

Oracle Enterprise Asset Management - Version 12.2.4 and later
Oracle Enterprise Command Center Framework - Version 12.2.4 and later
Information in this document applies to any platform.


When attempting to run ECC Data Load program, observe it fails with following error

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at "APPS.EAM_ECC_ASSETS_UTIL_PVT", line 2258ORA-06512: at line 1


To reproduce the issue, use below steps

1. [R] Enterprise Asset Management

2. Run Enterprise Asset Management Command Center Data Load

3. Observe the workers for dataset = eam-asset and dataset = eam-asset-attrs fails with the specified error








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.