EOAW_COMMENT APP ENGINE PROCESS- Performance (Doc ID 2255131.1)

Last updated on JULY 05, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
PeopleSoft Enterprise FIN Program Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Performance issue when trying to run wide open after applied Bug 22815612: PERFORMANCE ISSUE WHEN RUN EOAW_COMMENT APPLICATION ENGINE PROCESS to allow run the EOAW_COMMENT process by process id.


A couple of process ids as there are so many rows that it has to go through. The date on the page created by the bug fix is only a from date and not a date range.
Trying to run it for everything but when using wide date, the process will run at least 4 days before eventually have to be killed it due to performance issues.


STEPS
-----------------------
1. Run the EOAW_COMMENT process by process id wide open, to have all of the 9.1 comments available on the new 9.2 comment tables.


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