Authorization Schemes in APEX can be evaluated at:

Once per page view : Checks authorization each time a page is rendered.

A dynamic List of Values (LOV) in APEX populates options based on a query source. The supported types include:

Function Returning SQL Query : A PL/SQL function that returns a SQL query string (e.g., RETURN 'SELECT ename, empno FROM emp';). This offers flexibility for dynamic conditions or complex logic.

SQL Query : A direct SQL statement (e.g., SELECT ename, empno FROM emp) executed at runtime to fetch LOV values. It’s the simplest and most common approach.

Procedure : Procedures execute logic but don’t return query results in the format required for an LOV (they don’t produce a result set directly).

The "Generate Text with AI" Dynamic Action uses Generative AI to:

Draft an email : Creates text content like emails based on prompts.

Declarative options for downloading BLOB/CLOB content include:

Download Dynamic Action : A built-in action type to trigger downloads of BLOB/CLOB data.

By default, faceted search can "batch" changes, requiring an "Apply" button click to filter the report. To enable automatic filtering:

Disable the Batch Facet Changes attribute : In Page Designer, under the Faceted Search region’s Attributes, setting "Batch Facet Changes" to "No" ensures the report refreshes immediately when a facet value is selected, improving responsiveness. This triggers an AJAX call to update the report without a manual submit.

Show Facet Name : This controls facet label visibility, unrelated to filtering behavior.