ETL9.1 ENH - TL_DATES_TBL And TL_DSTOFFSET Should Be Handled Same Way To Stay In Sync
Last updated on NOVEMBER 08, 2016
Applies to:PeopleSoft Enterprise HRMS 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.
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