My Oracle Support Banner

Application Engine (AE) Process DCAW26326249 Running For Long Time While Applying FSCM Image 33 (Doc ID 2650777.1)

Last updated on MARCH 20, 2020

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

While applying PUM 33 patches to PSFT 9.2/8.57.10 instance encountered severe performance issue with below SQL which ran for 24+ hours.


SQL Text : UPDATE PS_PO_AW SET EOAWDTTM_MODIFIED = (SELECT   MAX(U.EOAWDTTM_MODIFIED) FROM PS_EOAW_USERINST U WHERE   U.EOAWSTEP_INSTANCE IN (SELECT S.EOAWSTEP_INSTANCE FROM   PS_EOAW_STEPINST S WHERE S.EOAWTHREAD_ID =   PS_PO_AW.EOAWTHREAD_ID AND S.EOAWPRCS_ID = :1)) WHERE   EOAWPRCS_ID=:2 AND EOAWDTTM_MODIFIED IS NULL

Steps to reproduce the issue:

1. Apply FSCM 9.2. PUM Image 33
2. Run Data Conversion AE - DCAW26326249
3. Process gets stuck at the above sql

 

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


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