Enterprise Asset Management Command Center Full Data Load Fails with ORA-06502/ORA-06512 at "APPS.EAM_ECC_ASSETS_UTIL_PVT"
(Doc ID 2727234.1)
Last updated on MARCH 02, 2022
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. Responsibility Enterprise Asset Management
2. Run Enterprise Asset Management Command Center Full Data Load
3. Observe the workers logs 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