APEX 5.14
Oracle Express 18c
I am going through my application and updating Tabular Forms regions, to Interactive Grid editable regions.
When I attempt to run the Advisor I get this error on 'some' pages that include IG regions... so not all pages with IG regions.
When getting this error I do not get the advisor page showing detail...
When selecting more than one page to review, the error prevents the advisor process to show ANY detail for any page .
Additionally - this error only shows up when 'Checks to Perform' includes 'Declarative References of Application Items, Page Items, Columns or Interactive Report'
Example is Page 56 which has one static region with page items, and one IG region using a collapsible template; using a query against the same table the static region uses to insert rows. There are no 'case' statements on the page in either region - so it seems the error message has more to do with the advisor process.
Any ideas on cleaning this up? I am being forced to review each page, one page at a time to find out which are causing the error - and that is really impacting time to deliver, preventing the advisor to run on those pages - or reducing the value of the Advisor by not using that Check.
RichDW