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 MAY 23, 2017

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 :  8.54 version, 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;




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms