Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Unable to resolve " ORA-01427: single-row subquery returns more than one row" — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to resolve " ORA-01427: single-row subquery returns more than one row"

Received Response
32
Views
4
Comments

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!