ORA-00901 Multiple Interactive Reports On a Page With Control Break And Aggregation (Doc ID 2100849.1)

Last updated on FEBRUARY 01, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 5.0.2.00.07 and laterInformation in this document applies to any platform.

Symptoms

Problem--------------There are two interactive reports on a page.Each interactive report is based on a different table/view.

The first interactive report has a control break on fields that are not in the second interactive reports. This has been saved as the primary default report.The second interactive report has an aggregation and has also been saved as the primary default report.

What does not work-----------------------------------------When running the page the second interactive report region shows the following error:

ORA-00904 “nnnn” invalid identifier

Where nnnn is the field used for the control break on the 1st interactive report.