My Oracle Support Banner

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

Last updated on FEBRUARY 29, 2024

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 8.8 SP1 to 9.2 [Release 8.8 to 9]
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201002402

*** **


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

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