Requisition Worklfow Setup Having One step With no User is Making all the Subsequent Steps to be Skipped And Move to Admin Error Step When Using Query Based Userlist (Doc ID 2765612.1)

Last updated on MARCH 06, 2023

Applies to:

Symptoms

In the "Requisition" Approval Process Setup, we had to introduce multiple Path and Steps with respective criteria.

Requisition Worklfow Setup having one step With no user is making all the subsequent steps to be skipped and move to "Admin Error" Step when using Query Based Userlist

S basically when there are no user found in one of the steps, its skipping all the subsequent steps and moving to the "Admin Error" step. Even though, we have setup the "Error Action" as "Route to next step on error".


Steps to reproduce the issue:

1) Create Queries as below:
Reporting Tools> Query> Query Manager
Using the roles, create the queries, the path has the below:
APPROVER2 Query
APPROVER3 Query
APPROVER4 Query

2) Navigate to User list Setup Page (Enterprise Components > Approvals > Approvals > User List Setup)
Set a User List Definition for each query, the below is an example, showing
that query is used and that the setting for "Include Users as Input" and "Transaction Keys as Input" are ticked.

ROLE2 -- tied to APPROVER2 Query
ROLE3 -- tied to APPROVER3 Query
ROLE4 -- tied to APPROVER4 Query
ROLE5 -- Role based tied to Role5
PLEASE NOTE ROLE5 is not assigned to any user

3) Assign all 3 Roles (2,3,4) to the one user that will be creating the requisition (VP1).
This is just a way of easily showing that the user would exist in each query.
4) Create a Approval Process Definition (Enterprise Components> Approvals > Approvals > Approval Process setup- Choose Requisition)
5) Click on Preview Approval Process in the setup:
6) Go to Preview Approval Path
The path shows that valid approver steps (3rd,4th,5th) have also been skipped evne though the query for the third, fourth and fifth steps shows that a user is available.

Please see attached Replication document for more details.

 

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.