Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
ORA-01427; single-row subquery returns more than one row error on data model
Summary
Receiving oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row.Content
Hello,
We just started receiving the below error on a report we have been running for over 2 years. I am not sure which sub-query is pulling in multiple rows. Any help would be greatly appreciated. Attached is the SQL
oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
0