Unable to resolve " ORA-01427: single-row subquery returns more than one row"
Summary:
Hi Experts,
When I open a BI report, I am getting, "ORA-01427: single-row subquery returns more than one row" Error. I checked each subquery and all subquery returns only one row. I followed https://ittutorial.org/ora-01427-subquery-returns-more-than-one-row/ as per this instruction and still unable to resolve the issue.
We are using a parameter for legal entity, for one legal entity the output is coming, for some legal entity the output is empty and for some legal entity it throws, "ORA-01427: single-row subquery returns more than one row" this error.
Any solution for this issue?
Content (required):
Version (include the version you are using, if applicable):
Tagged:
0