Requisition Approval Workflow Stuck Issue (Doc ID 2215112.1)

Last updated on JUNE 24, 2024

Applies to:

Symptoms

Issue:- The Requisition didn't routed to the Next Approver and the Requisition status remains in Pending.The issue is intermittent and not consistently replicable

Steps To Reproduce the Issue:-
The issue can be reproduced at will with the following steps:
1. Create an Requisition and submit it for Approval such that 2-3 Approval levels are there.
2. Approve from the first approvers
3. Approve from second Approver
4. Note that the requisition didn't routed for the next approver and status is pending(awaiting further Approvals)

Observation:-The Approval status status remains Awaiting Further Approvals, yet no rows in USERINST record

Such transactions can be identified using the below query:

select aw.eoawparent_thread, req_id, business_unit from ps_pv_req_aw aw where aw.eoawthread_id = aw.eoawparent_thread and aw.eoawthread_status = 'A' and aw.eoawthread_id in
(select eoawthread_id from ps_eoaw_stepinst where eoawprcs_id = 'Requisition' and eoawstep_status in ('N', 'I'))
union
select aw.eoawparent_thread, req_id, business_unit from ps_pv_req_aw aw where aw.eoawthread_id <> aw.eoawparent_thread and
exists (select 'x' from ps_pv_req_aw req where req.eoawthread_status = 'S' and req.eoawthread_id = aw.eoawparent_thread) and
exists (select 'x' from ps_pv_req_aw req2 where req2.eoawparent_thread = aw.eoawparent_thread and
((req2.eoawthread_id <> req2.eoawparent_thread and req2.eoawthread_status in ('A', 'D'))
or (req2.eoawthread_id = req2.eoawparent_thread and req2.eoawthread_status = 'S')))
and aw.eoawthread_id in (select eoawthread_id from ps_eoaw_stepinst where eoawprcs_id = 'Requisition' and eoawstep_status in ('N', 'I'));

This is only for Requisition. “ps_pv_req_aw” would need to be replaced for each transaction which needs to be checked.

Cause

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