My Oracle Support Banner

ETL9.2: SQL Objects TMPL000_S100, TMPL000_S101 Use Missing Records TL_DUR_TMP1, TL_DUR_TMP2 (Doc ID 1905857.1)

Last updated on JULY 02, 2020

Applies to:

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


HRMS 9.2 PUM 6

It appears delivered sql objects TMPL000_S100 and TMPL000_S101 reference records TL_DUR_TMP1 and TL_DUR_TMP2 respectively, but the records are not found in app designer.

Using delivered SQL objects in a rule causes Time Admin process to fail.

Steps to Recreate:
Navigation: Set Up HCM, System Administration, Utilities, Build Time and Labor Rules, SQL Objects
1. Pull up SQL object TMPL000_S100. Note is references record TL_DUR_TMP1.
2. Pull up SQL object TMPL000_S101. Note is references record TL_DUR_TMP2.
3. Go to App Designer and attempt to pull up records TL_DUR_TMP1 and TL_DUR_TMP2. Neither record exists.




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.