BI Publisher11G Report Displays "No Data" or "No data found" Error When the Data Model has "Long" Datatype When Dragging Data Elements In A Report Using Interactive Reporting (Doc ID 2019228.1)

Last updated on APRIL 22, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.7.x and later
Information in this document applies to any platform.

Symptoms

Only simple Data Models work using Interactive Reporting.  Gives a "No data found" message when dragging data elements into the report.  

If the report is built in the Layout Editor and edited there a table might show "No data found" in one or more columns.

Changes

 New data model and report are created.

Cause

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