FDMEE EBS GL Source Initialization Failing with ORA-01427: Single-row Subquery Returns More Than One.
(Doc ID 3074816.1)
Last updated on MARCH 04, 2025
Applies to:
Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.2.15.0.000 and laterInformation in this document applies to any platform.
Symptoms
Affected Version: FDMEE 11.2.15.0.000
Problem Description
The EBS GL Source Initialization is failing in FDME, resulting in the following error:
ORA-01427: single-row subquery returns more than one row
This issue occurs during the EBS Extract Ledger EBS COA Segments TL process while executing the Loading-SrcSet0-Load data operation. The process is responsible for loading data into the target table AIF_EBS_COA_SEGMENTS_TL_STG.
Error Details
ODI-1227: Task Loading-SrcSet0-Load data fails on the source connection EBS_DATA_SERVER.
Caused by: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
This error indicates that a subquery in the process is returning multiple rows when only a single row is expected, causing the operation to fail.
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 |
| Cause |
| Solution |
| References |