My Oracle Support Banner

Error In EAM Command Center Data Load Request ORA-01427 and ORA-06512 at EAM_ECC_ASSETS_UTIL_PVT (Doc ID 2803112.1)

Last updated on SEPTEMBER 06, 2021

Applies to:

Oracle Enterprise Asset Management - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On EAM - Oracle Enterprise Asset Management, 12.2.9 version, Enterprise Command Center

Error in EAM Command center data load request (ECCRUNDL: ECC Run Data Load for EAM) for eam-asset data set.

ERROR
-----------------------
ORA-01427: single-row subquery returns more than one rowORA-06512: at "APPS.EAM_ECC_ASSETS_UTIL_PVT", line 774492664ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Enterprise Asset Management Command Center Data Load for full or incremental.
2. See "ECCRUNDL: ECC Run Data Load" request in error for eam-asset set.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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