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