My Oracle Support Banner

EOAW Comments App Engine Is Not Bringing OPRID In Comments From 9.1 To 9.2 (Doc ID 2509514.1)

Last updated on JANUARY 07, 2020

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Problem Description
---------------------------------------------------
After running the app engine EOAW_COMMENT, the comments are NOT migrating completely; OPRID is missing.

Navigation: Enterprise Components > Forms > Approve/Review and Form

Upgrade Step
Task 8-14: Migrating Approval Comments Data
In this task you run the Application Engine program EOAW_COMMENT, which migrates the approval
comments in the XREF tables delivered with the Comment Redesign feature to the new tables
EOAW_COMMENTS and EOAW_HIS_COMM. You need to manually select the Application Engine program
EOAW_COMMENT to run it. The EOAW_COMMENT Application Engine program retrieves all comments
data from each XREF table registered in EOAW_TXN. It then parses SUDO XML comments, retrieves
meaningful comments, and saves them in the two new tables, EOAW_COMMENTS and EOAW_HIS_COMM.
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.

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
References


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