ETL9.2:Record TL_DUR_TMP1 And TL_DUR_TMP2 Not Defined In HCM92

(Doc ID 2240060.1)

Last updated on MARCH 22, 2017

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
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

The issue has the following business impact:
Due to this issue, users cannot process employee's time on time


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