Requisition Approval Workflow Stuck Issue
(Doc ID 2215112.1)
Last updated on APRIL 26, 2021
Applies to:PeopleSoft Enterprise SCM eProcurement - Version 9.1 and later
PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.
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'))
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document