Hello,
I’m working with Oracle APEX on a project involving multiple approval steps for invoice creation. I’m encountering difficulties in retrieving the approver(s) from task definitions using SQL queries.
Here’s the scenario: When an invoice is created by Person 1, it needs approval from Person 2, then Person 3, and so forth for a total of four approvers. We are using :APP_USER to determine the creator of the invoice, and we need to identify the corresponding approvers from our database table.
However, the SQL query used in the participants' task definitions a simple query(e.g., SELECT "name" FROM "tablename") is not returning any approver data as expected.
Could you please advise if there are any settings adjustments or additional processes needed to resolve this issue?
I'm checking on basis of level_code
Waiting for the reply.
Thank you