Hi,
I was trying to create a faceted search page for a table in a different schema using the wizard but I am getting ORA-00942: table or view does not exist on APEX 23.2.6.
This table had grant select on the schema user associated to the workspace and the schema is also present in the list of workspace schemas, so I tried giving grant select to APEX_230200, then to APEX_PUBLIC_USER and even to PUBLIC, but the error persists.
I tried also GRANT ALL to PUBLIC but it still complains with the same error.
Is there any known bug and or a workaround for this situation?
I would like to use the wizard specifying schema and table because I could theoretically get the filters for some FKs automatically created as explained by the documentation:
“_When you build a faceted seach page with either the Create Application Wizard and Create Page Wizard, you can select a table or view on which to build the page. If you create the page based on a table, the facets are auto-discovered using the Data Dictionary Cache”_
Flavio