ETL9.2: Upgrade From 8.9 - 9.2 PS_TL_EMPL_DATA.PROCESS_INSTANCE Set To 0 (Doc ID 1639987.1)

Last updated on SEPTEMBER 09, 2015

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Goal

In Time and Labor 9.2,

We are doing an 8.9 to 9.2 upgrade and the new field PS_TL_EMPL_DATA.PROCESS_INSTANCE is set to 0 during the install and was never set to a different unique value for each record. however, when trying to save time on the timesheet this row is not allowed to be 0 or is causes an error.

What process is it that is supposed to change this value?
 
We tested changing a single user to that value and it worked fine. however, we have some questions

- do we set this value for all rows in that table, because we thought the value had to be unique across employees?
- what process is supposed to set these values? this is our second run at upgrading and the first upgrade updated this field but the second upgrade didn't
 

 

Solution

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