Hi,
We are facing some challenges with the APEX_APPROVAL.GET_TASKS function. As per the documentation, if the p_context is set to MY_TASKS, it will return the list of tasks that are assigned or unassigned with the user as a potential owner. However, we feel that it is not working as expected.
Steps followed.
Launch the Sample Approval app provided by Oracle.
Create a task definition.
Set the potential owner with the username. E.g. if my username is 'ARUN@EXAMPLE.COM', set the potential owner as 'ARUN@EXAMPLE.COM'
Create a page, add a button, and set the behavior to submit the page.
In the processing tab, add the process of the type 'Human Task - Create' and select the task definition created before.
Run the page and click the button. It should create a task.
Go to My Approvals and notice that the task is not listed there.
Go to Pending Approvals. This page list this task and we can see that it is assigned to the user.
We expect that the task to be listed in My Approvals as the potential owner was set.
What could be the reason for not listing the task in My Approvals?