My Oracle Support Banner

Oracle Fusion BI Publisher: The BI Publisher report fails with "Failed To Load Servlet/dmvalidate Error When Compiling A Data Model. ORA-01427: single-row subquery returns more than one row" (Doc ID 1927349.1)

Last updated on JANUARY 29, 2018

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.8.0.0 and later
BI Publisher (formerly XML Publisher) - Version 11.1.1.7.0 and later
Oracle Fusion Global Payroll Cloud Service - Version 11.12.1.0.0 to 11.12.1.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On :  11.1.8.0.0 version, Technology Management - Reports/Analytics
 
When trying to run the report or compile the sql in the data Model, you tend to get similar errors:


ERROR
-----------------------
XML Parsing Error: mismatched tag. Expected: .Location: https//..../xmlpserver/servlet/xdo Line Nubmer 2, Column 580:
Failed to load servlet/dmavaildate

"Failed To Load Servlet/dmvalidate Error When Compiling A Data Model. ORA-01427: single-row subquery returns more than one row"




Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.