My Oracle Support Banner

E-AWE: Approval Workflow Comments Missing After Upgrade to PS 9.2, Or What Is The Best Strategy For Comment Conversion Performance With EOAW_COMMENTS During Upgrade? (Doc ID 2272857.1)

Last updated on MAY 01, 2023

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
PeopleSoft Enterprise SCM eProcurement - Version 9.2 and later
Information in this document applies to any platform.

Goal

In situation of either Approval Comments conversion process was skipped and Comments were found missing after the upgrade, or running the EOAW_COMMENT program takes too long for large amounts of Approval data, or just looking for the best strategy for performing the Approval Comment conversion for upgrade task after reviewing the following in Upgrade documentation.

PeopleSoft Human Capital Management Upgrade Home Page (Doc ID 1959519.2)   See Task 8-14: Migrating Approval Comments Data, in this HCM 9.2 Pi 24 Document
PeopleSoft Financials and Supply Chain Management Upgrade Home Page (Doc ID 1963697.2) See Task 8-3: Migrating Approval Comments Data, in this FSCM 9.2 Pi 26 Document.

Migrating Approval Comments Data

Warning! This Application Engine program can be executed only once during the upgrade. If any exception occurs, truncate the two new tables and rerun the EOAW_COMMENT Application Engine program.

The Application Engine program will check whether any data already exists for a processs_id bind with a thread_id as it only migrates threads without data. For example, if comment A with thread_id 11 and process_id 101 already exists in the EOAW_COMMENTS table, then the Application Engine will skip migrating comment A.

 

What is the best approach in PS 9.2 for implementing the Approval Framework Comment Conversion using EOAW_COMMENT Application Engine(AE) program?

 

 

Solution

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
Goal
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.