ETL9.2:Time Administration Abend At TL_TA001100.DD000.Step02

(Doc ID 2292796.1)

Last updated on AUGUST 09, 2017

Applies to:

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

Symptoms

On : 9.2 version, Time Administration

Time Administration Abend

Time Admin failed at Step TL_TA001100.DD000.Step020


 

ERROR
-----------------------


File: e:\pt85516b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 8150 - Left-of-decimal digits truncated from FETCHed value (SQLSTATE PS150)
Failed SQL stmt: SELECT (((LAST_SEQ_PAY_TIME - 1 + 1)) * ( 1000000.0)) FROM PS_TL_INSTALLATION

Process 81279 ABENDED at Step TL_TA001100.DD000.Step020 (SQL) -- RC = 8150 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 11.13.46 2017-07-24



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Time Admin and it abends with above error
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process employee's time and employees may not get paid

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