ETL9 How to Add Calendar Years with the Load Dates Process w/out Deleting History (Doc ID 760409.1)

Symptoms

When running the Load Dates App Engine process TL_LOADDATES which is initiated from the TL Installation page the process removes all existing data from the PS_TL_DATES_TBL record and then inserts only the number of years specified on the Dates Table Load page. How do you load new calendar years without deleting all of this historical data in the TL_DATES_TBL? For instance, we have data in the TL_DATES_TBL dating back to year 1995 and the Load Dates process can only be run for a maximum of 10 years which would delete 1995-1997 data from this record. If we ran it for anything less than 10 years additional years would be deleted. We don't want any history in the TL_DATES_TBL to be overwritten we simply want to load a future calendar year. How can this be done?

We would like to keep the historical data in this record because we do sometimes have a need to go back many years to make adjustments to time due to Union negotiations/legal actions and contract changes. There is nothing in the system that prevents making prior period adjustments years back and Time Administration processes them fine (although yes it might take a little longer for that particular employee).

In addition, we keep the dates associated to our PERIOD_ID values on the PS_TL_CALENDAR historically so it would make sense that the TL_DATES_TBL would also hold these historic values. Wouldn't the associations between these records be lost if history for one was removed?

It seems to me like this should be an incident to fix the TL_LOADDATES program not an enhancement. If we are following referential integrity it would make sense that these records keep their historical information.

Cause

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