Hi everyone,
After upgrading to Oracle APEX 24.2 on my OCI instance, I noticed that workflow human tasks are missing from the MY_TASKS context when using the apex_approval.get_tasks(p_context => 'MY_TASKS') function.
However, the same tasks are visible in the APEX_TASKS view, and participant details are available in the APEX_TASK_PARTICIPANTS view. Additionally, when checking an individual task using apex_approval.get_tasks(p_context => 'SINGLE_TASK') with a task ID, the details are correctly returned.
The tasks that were initiated after the upgrade appear in the MY_TASKS context without any issues.
Also, I'm not sure if this happened due to any mistake I made during the upgrade.
What could be the reason for the older tasks not appearing in MY_TASKS?
Is there a way to rebuild or refresh the data associated with the MY_TASKS context so that older tasks are picked up?
Any guidance would be greatly appreciated. Thank you!
@ralf-mueller-oracle @ananya-chatterjee-oracle