ETL 9.2:TL_TIMEADMIN Abort Error in section: TL_TR0012904.PRIORADJ.STEP03

(Doc ID 2318407.1)

Last updated on OCTOBER 17, 2017

Applies to:

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

Symptoms

On : 9.2 version, Time Administration

TL_TIMEADMIN Abort error

T&L Time Admin process is aborting in this section: TL_TR0012904.PRIORADJ.STEP03
when a user does not have allow prior period adjustments on their TL Security Role, and there is prior period time.
The process is trying to put timecardeport into the PS_TL_EXCEPT_WRK EMPLID field, causing SQL error String Data Right Truncation:

INSERT INTO PS_TL_EXCEPT_WRK3 (PROCESS_INSTANCE , VALID_INST_ID , UPDATE_FLAG
, EXCEPTION_ID , EMPLID , EMPL_RCD , DUR , SEQ_NBR , EXCEPTION_SOURCE ,
SEVERITY , RUN_CNTL_ID , EXCEPTION_STATUS , RESOLVED_BY , ACTION_DTTM ,
START_DT , END_DT , ALLOW_IND , MSG_DATA1 , MSG_DATA2 , MSG_DATA3 , MSG_DATA4
, MSG_DATA5) SELECT :1 , :2 , 'N' , :3 , A.EMPLID , A.EMPL_RCD , A.DUR ,
A.SEQ_NBR , A.EXCEPTION_SOURCE , ' ' , :4 , 'U' , ' ' , CURRENT TIMESTAMP ,
'1900-01-01' , '1900-01-01' , ' ' , CAST(:5 AS CHAR(10)) , ' ' , ' ' , ' ' ,
' ' FROM PS_TL_VALID_DATA3 A WHERE A.PROCESS_INSTANCE = :6 AND A.EMPLID = :7
AND A.EMPL_RCD = :8 AND A.DUR <= :9
/
– Bind variables:
– 1) 323
– 2) 323
– 3) TLX01770
– 4) timecardreport
– 5) 2017-06-17
– 6) 323
– 7) 0206893
– 8) 0
– 9) 2017-06-17
– Row(s) affected: 0
– 16:10:54.063 Process 323 ABENDED at Step TL_TR0012904.PRIORADJ.Step03 (Action SQL) – RC = 8622
ROLLBACK
/
– 16:10:54.067 SQL Error: [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001 (SQLSTATE 22001) -99999
 

ERROR
-----------------------
Process 323 ABENDED at Step TL_TR0012904.PRIORADJ.Step03 (Action SQL) – RC = 8622

[IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001 (SQLSTATE 22001) -99999

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