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