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!

Multiple approvals in workflow not reading the sql query in task definitions participants

shashi.ranjanAug 21 2024

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

Comments
Post Details
Added on Aug 21 2024
4 comments
277 views