This content has been marked as final. Show 5 replies
The APEX_PLSQL_JOB.SUBMIT_PROCESS function populates table WWV_FLOW_JOBS in the FLOWS_030nnn schema. The view apex_plsql_jobs references that table so can you see any data in the WWV_FLOW_JOBS table? The privileges to this table are restricted so you will need to log in as sys to see it.
Also, if you run the PL/SQL block you have in the On Load before Header process in the SQL Workshop and then run SELECT * FROM apex_plsql_jobs does it return any records.
apex_plsql_jobs relies on
So you need to run it within your apex session. I created a new page with your On-load process and an unconditional report with a source of
SELECT nv( 'FLOW_SECURITY_GROUP_ID' ) sgid FROM DUAL
Everything shows up fine here for me (not if queried through SQLplus though as security group isn't set-up).
SELECT * FROM apex_plsql_jobs
Don't forget to mark replies helpful or correct ;)
If it is in the WWV_FLOW_JOBS table then the job has been submitted successfully. Is the system_status column set to 'COMPLETE'?
You only need to set the security group if you are running the code outside of APEX.
Have a look at my example on apex.oracle.com
Workspace : EDIDEV
Username : USER
Password : jadohi
Run App Flow Jobs Example - 33462
Enter a value in Enter Val Text field and press Submit
The process will insert a record in the flow jobs table, you may need to press refresh to see the job complete and for the value to appear in the PT_TEMP_TABLE