My Oracle Support Banner

ETL9.2:Record TL_DUR_TMP1 And TL_DUR_TMP2 Not Defined In HCM92 (Doc ID 2240060.1)

Last updated on JULY 22, 2020

Applies to:

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


On : 9.2 version, Time Administration

Record TL_DUR_TMP1 and TL_DUR_TMP2 Not defined in HCM92

HCM 9.2 PUM18

It appears delivered sql objects reference records TL_DUR_TMP1 and TL_DUR_TMP2 respectively, but the records are Not found in app designer(HCM 9.2 , Tools 8.55).

One of the Child process TL_TA_RULES of TL_TIMEADMIN Core Time Administration, failed due to Record TL_DUR_TMP1 and TL_DUR_TMP2 Not defined.


Starting TL_TIMEADMIN Core Time Administration App. (13507,13)
Record TL_DUR_TMP1 not defined (108,505)
Meta-SQL error at or near position 36 in statement (108,512)
Process 963614 ABENDED at Step TL_TA_RULES.012TO011.Step07 (SQL) -- RC = ? (108,524)

The issue can be reproduced at will with the following steps:
1. Employees assigned to rules
2. Submit time for various employees.
3. Run time admin and it abends on above step




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

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