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

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

Summary:

Hi All,

We encountered the below error in a specific report DM both while running the report and within the DM itself. After identifying and resolving the issue in the SQL query, the DM now returns results correctly. However, the error still appears when running the report, which is unexpected. Requesting inputs from the experts for a fix to this.

Kind Regards,

Abhijit Nair

Content (please ensure you mask any confidential information):


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



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!