ETL9.2 TL_TIMEADMIN Runs To No Success If Rows On PS_TL_RI_CNTRL_TBL (Doc ID 2032897.1)

Last updated on DECEMBER 19, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ISSUE STATEMENT
--------------
If there are any rows on PT_TL_RI_CNTRL_TBL, TL_TIMEADMIN will run to No Success. We are on HCM9.2 PUM12, PT 8.54.12.
Process 396007 ABENDED at Step TL_RI_RESOLV.MAIN.Step090 (Do Select) -- RC = ? (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

ENVIRONMENT
-----------
PeopleSoft HCM 9.2
PeoplTools 8.54
Environment: Production

ERROR
--------
The error in the log will be:
--------------------------------------------
PeopleTools 8.54.12 - Application Engine Server
Copyright (c) 1988-2015 Oracle and/or its affiliates.
All Rights Reserved


PSAESRV started service request at 11.24.51 2015-07-16
2015-07-16-11.24.54.000000: Starting TL_TIMEADMIN Core Time Administration App. (13507,13)
2015-07-16-11.24.54.000000: Starting TL_RI_RESOLV Rule Integrity Checking. (13507,13)
Process 396007 ABENDED at Step TL_RI_RESOLV.MAIN.Step090 (Do Select) -- RC = ? (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 11.24.55 2015-07-16
PSAESRV started service request at 11.26.22 2015-07-16
Process 396007 resumed after step TL_RI_RESOLV.MAIN.Step080U (108,538)
2015-07-16-11.26.23.000000: Starting TL_TA000200 Determine TRs To Process. (13507,13)
Reserved 0 Time Reporters for processing. (13507,8)
No employees are available for processing. (13507,972)
Application Engine program TL_TIMEADMIN ended normally

PSAESRV completed service request at 11.26.24 2015-07-16

REPLICATION STEPS
-------------
1) Run Time Admin after applying PUM 11
2) Time Admin goes to No Success with following error:
Process 396007 ABENDED at Step TL_RI_RESOLV.MAIN.Step090 (Do Select) -- RC = ? (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

WHAT IS WORKING
--------------
Time Admin was working without issue in PUM 10

BUSINESS IMPACT
---------------
Due to this issue customer cannot create payable time, due to this employees are not being paid correctly. this involves several hours of manual work & it cost to the company.

Cause

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