Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
when i ran My Bi reports I'm getting error is ORA-01427: single-row subquery returns more than one — 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

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

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

Summary:

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.

Register

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