BIP Report Not Working : Error occurred on retrieving data xml

(Doc ID 2290847.1)

Last updated on JANUARY 01, 2018

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.11.1.0 version, Analytics

BIP Report Not Working

We have created a BIP report using SQL data model, currently the report shows below columns- 1.Last Logn Time 2.Username. We have given a filter condition to show only data 24 hours before the current date. When we try to add column user email id into the sql data model and try to run the report we are getting below error message "Error occurred on retrieving data xml". Steps to replicate are as follows-
1.Create data model using sql query.
2.Add user email column,which comes from table per_email_addresses.
3.Create report using data model.
4.Error message will be displayed when we try to run the report.

Kindly let us know if there is anything wrong with the query, attaching below error screenshot and query used.
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms