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 NOVEMBER 08, 2016

Applies to:

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

Symptoms

 

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.

 

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