My Oracle Support Banner

E-BI Publisher: Group Left Shows No Data Found When Having Compatibility Mode Enabled (Doc ID 2993772.1)

Last updated on FEBRUARY 01, 2024

Applies to:

BI Publisher (formerly XML Publisher) - Version 12c to 12c [Release 12.0]
Information in this document applies to any platform.


In BI Publisher, when using Group Left functionality in a Report with 8 columns or more, the functionality does not work if Compatibility Mode is enabled in Administration > Runtime Configuration > Properties.

When editing the Report, No Data Found will be displayed in the Group Left column when when trying to Open the Report.


  1. Create a Data Model
  2. Verify Compatibility Mode is not enabled
  3. Create a Report using the above Data Model
  4. Use the Layout Editor to create a BI Publisher layout (XPT) with a table with at least 8 columns
  5. Use the Group Left functionality for several columns (at least up to the 8th column). Verify no issues occur
  6. In Administration > Runtime Configuration > Properties, set Compatibility Mode to True
  7. Edit the Report and verify No Data Found appears in the column instead of the expected values from the XML file. 




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

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