My Oracle Support Banner

ETL9.1 ENH - TL_DATES_TBL And TL_DSTOFFSET Should Be Handled Same Way To Stay In Sync (Doc ID 1670452.1)

Last updated on MAY 28, 2020

Applies to:

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



When we Load Dates via the installation table and click load dates - the
process only truncates from current date onwards and reloads TL_DATES_TBL but
truncates TL_DSTOFFSET completely.


So we still end up with 18 (1998-2016) on TL_DATES_TBL but only 4 years
(2012-2016) in TL_DSTOFFSET (If we give 4 as the years to load).

We would like an enhancement request for TL_DSTOFFSET to be handled the same
way as TL_DATES_TBL – i.e. NOT deleted so the tables stay in sync.





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

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