My Oracle Support Banner

E-AWE: The Application Engine Process DC_EOAW_SUMM Delivered To Populate AWE Summary Tables Has Been Running For 10+ Hours (Doc ID 2104636.1)

Last updated on JULY 16, 2018

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
PeopleSoft Enterprise SCM eProcurement - Version 9.2 and later
PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.

Symptoms

On :  HCM 9.2 Pi 15 (FSCM 9.2 Pi 15), Approval Framework (AWE) for Fluid Approvals


The Application Engine (AE)  Process DC_EOAW_SUMM, delivered with the HCM 9.2 PUM 15, has run for 10+ hours.  It appears to be hung on the DC_EOAW_SUMM.Main.Insert2(Peoplecode) step.

This is too long to run for implementation, what is the functionality of this SQL and how can this be fine tuned?

Expect that no AE conversion programs delivered with HCM/FSCM 9.2 PUM 15 should take so long to run.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Implement HCM 9.2(or FSCM) Pi 15.
2. Observe that the DC_EOAW_SUMM data conversion program was selected to run.
3. Observe that the program appears to be hung, taking over 10+ hours to run, on the DC_EOAW_SUMM.Main.Insert2(Peoplecode) step which is running this code;

SQLExec("insert into PS_EOAW_SUMM_DTL (EOAWTHREAD_ID, EOAWPRCS_ID, EOAWAPPROVER_OPRID, EOAWPARENT_THREAD, EOAWORIG_OPRID, EOAWUSTEP_STATUS, EOAWPREV_STATUS,LASTUPDDTTM,LASTUPDOPRID,CREATEDTTM) select distinct step.eoawthread_id, step.eoawprcs_id, step.oprid,0, step.eoaworig_oprid, step.eoawstep_status, 'A', u.eoawdttm_modified,  step.oprid,step.DTTM_CREATED from ps_eoaw_step_vw step, ps_eoaw_userinst u where step.eoawustep_inst_id = u.eoawustep_inst_id and step.eoawstep_status not in ('K','G') and step.eoawustep_inst_id = (select max(sub.eoawustep_inst_id) from  ps_eoaw_step_vw sub where sub.eoawthread_id = step.eoawthread_id and sub.oprid = step.oprid and step.eoawprcs_id = sub.eoawprcs_id)");




Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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