My Oracle Support Banner

ETL9.2:Why there are two delivered history records (TL_COMP_DAY_HST & TL_EXCEPTN_HST) are missing key fields that are defined on the main records (TL_COMP_DAY_BAL & TL_EXCEPTION)? (Doc ID 2923353.1)

Last updated on JANUARY 24, 2023

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

Two delivered history records (TL_COMP_DAY_HST & TL_EXCEPTN_HST) are missing key fields that are defined on the main records (TL_COMP_DAY_BAL & TL_EXCEPTION).

This is a minor issue but this will require a customization to use a delivered archive object.

REPLICATION STEPS
-----------------------
1. In Application Designer, open TL_COMP_DAY_HST and compare with the keys defined on the main record TL_COMP_DAY_BAL.
2. The DATE_DUE is missing from TL_COMP_DAY_HST.
3. In Application Designer, open TL_EXCEPTN_HST and compare with the keys defined on the main record TL_EXCEPTION
4. The EXCEPTION_SOURCE key is missing from TL_EXCEPN_HST.


 

Solution

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
Goal
Solution
References


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