Change Assistant Runs Data Conversion AE - DCAW26326249 For a Very Long Time - Process Appears Stuck
(Doc ID 2479470.1)
Last updated on MARCH 02, 2020
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.
Customers report the process running for very long periods, more than 8 hours and even longer which delays the overall upgrade timing.
It is executing the following update SQL for more than 5 hours.
UPDATE PS_EP_APPR_XREF 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_EP_APPR_XREF.EOAWTHREAD_ID AND S.EOAWPRCS_ID = :1)) WHERE EOAWPRCS_ID=:2 AND EOAWDTTM_MODIFIED IS NULL
The issue may be replicated at will with the following steps:
1. Apply HCM 9.2. any PUM Image x
2. Run Data Conversion AE - DCAW26326249
3. Process gets stuck at the above sql
4. Tested in 2 different databases and issue remains the same
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