ETL8 & 9: Need some mechanism for correcting the TL_COMPLEAV_TBL history. (Doc ID 645716.1)

Last updated on MAY 17, 2017

Applies to:

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

This document was previously published as Customer Connection Solution 201002402


***Checked for relevance on 05-Mar-2010***
***Checked for relevance on 21-Oct-2011**


Symptoms

Need some mechanism for correcting the TL_COMPLEAV_TBL balances.        

For some time now, the inbound file publish has not been maintaining the TL_COMPLEAV_TBL or the TL_COMP_DAY_BAL table (we have a separate case for that).  In versions prior to 8.9 we had the UPGRADE_COMP and UPGRADE_LEAV to rebuild these tables but they are not available for this version.  We need some mechanism for correcting the history that has been compromised as a result of a programming error in the inbound file publish procedure.  If this process could be run for a single employee or a dynamic group instead of for the whole organization, it would be even more useful.

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