Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Workflow Human Tasks are missing after upgrading to Oracle APEX 24.2 in OCI

Robin BijuApr 26 2025 — edited Apr 26 2025

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

Comments
Post Details
Added on Apr 26 2025
15 comments
191 views