This is great, thanks. Did you also OCR the documents? How will they be retrieved / indexed?

The comparison is very helpful and informative. As far as "Improved printing and PDF export" Document Generator is a good first installment but compare to AOP and there is a long way to go and still more to be done at the basic reporting level. This includes easier integration with APEX. Hoping this doesn't mean Document Generator is done.

This is very helpful. Note: APEX_Application_Admin.Set_Application_Status parameters also changed in 24.2. the p_unavailable_value has become: p_redirect_url / URL to redirect to when p_application_status = c_app_unavailable_redirect.

I am trying to implement this with a more complicated query. Thoughts on a where clause like this, or one using between and dates? ( VW_Person.Person_Number = :APP_PERSON_PERSON Or :APP_IS_ADMIN = 'Y') And ( :P21_CRITERIA_STATUS = 'A' AND STATUS_TRAN_PERSON = 'ACTIVE' OR :P21_CRITERIA_STATUS = 'I' AND STATUS_TRAN_PERSON = 'INACTIVE' OR :P21_CRITERIA_STATUS NOT IN ('A', 'I')) And (:P21_CRITERIA_EPRGENRL_ID IS NULL OR Employer_ID = :P21_CRITERIA_Employer_ID); Note: Criteria_Status is a group letting the user select (A)ctive, (I)nactive, or Al(L) people. Thanks Joe

Very helpful both for the code, and the perspective. Are there security concerns here from having a function that creates a query from inputs vs. a "hard coded" query?

Thanks, this is very helpful. Is there a way to select which column value is returned, or is it always the primary key?

Very nice. FYI: Read my blog series "Mastering SQLcl Liquibase" link is broken.

Jon Dixon Hi Jon, FYI I went the dbms_scheduler route, but setting argument values for a PLSQL_BLOCK generates an error saying that type does not allow arguments. I handled it by pre-constructing the job_action to build the parameter values into the job_Action parameter value. Thanks again, Joe

Jon Dixon Hi Jon, Thanks for the quick and helpful options. I am thinking a good APEX Idea could be making it possible to fire a process with a custom event similar to DAs? Joe

Very well done, and helpful. I have an IG using FOS plugin to add Menu Items to "Actions Menu" that trigger a custom event that causes a Dynamic Action to fire executing PL/SQL code using Primary Keys of currently selected IG rows and other page item values. I want to move the PL/SQL code to a background process and cause it to fire as one of the actions of the Dynamic Action. Ideas on how to do that? In short, how to fire a background Process from a Dynamic action that uses Page Item values? It seems it has to be a button click event? Or a submit, but then I lose which items were selected? Thoughts? Thanks Joe