E-AWE: EOAW_SUMM_DTL Record Leaves a Row in a Pending Status For a Terminated Thread (Doc ID 2781649.1)

Last updated on AUGUST 13, 2024

Applies to:

Symptoms

When an approver modifies a pending transaction in their queue in a way that changes the routing, or resubmits it after another change that causes this approver to be removed from the routing, a row is left in a Pending status for this approver in EOAW_SUMM_DTL record for the terminated thread. The row should be in a Terminated status.

The issue can be reproduced using the following sample data and steps:

1. Requisition # 0000005250 for Business Unit 01900 is routed to approval process administrators on error step. This includes user ID 506993 (eoawthread_id 2219874), because of a missing approver on the first approval step.

2. An approver, Joe, is granted the missing route control for the requisition site, and now satisfies the routing criteria.

3. Approver 506993 resubmits the requisition to the approval process from the Approvals Monitor. The transaction is removed from error step approvers and routed to the correct approver Todd.

4. Execute the following SQL Select using a SQL Tool, and observe that EOAW_SUMM_DTL retains a row in a Pending status for terminated Approval Thread 2219874 and Approver ID 506993.

select * from sysadm.ps_eoaw_summ_dtl a where a.EOAWUSTEP_STATUS ='P' and a.EOAWAPPROVER_OPRID ='506993'

and not exists (select 'x' from sysadm.ps_PV_REQ_AW b where a.EOAWTHREAD_ID =b.EOAWTHREAD_ID

and a.EOAWPRCS_ID =b.EOAWPRCS_ID and b.EOAWTHREAD_STATUS ='P') and a.EOAWPRCS_ID ='Requisition';

Cause

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