BIP Report Not Working : Error occurred on retrieving data xml
Last updated on JANUARY 01, 2018
Applies to:Oracle Fusion Sales Cloud Service - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.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.
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