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

when i ran My Bi reports I'm getting error is ORA-01427: single-row subquery returns more than one

Received Response
edited Oct 26, 2022 5:16AM in Reporting and Analytics for HCM 13 comments


Hi Team,

when i run my report some countries coming data and some of times als coming the data but some times I'm getting below errror:

ORA-01427: single-row subquery returns more than one row

even schedule the job also same error coming

even i put the condtion : and ROWNUM <=1 then some times working but now not working.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


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