ETL 9.2 TL_TIMEADMIN Abends at STEP TL_TA000501.XA000.STEP060
(Doc ID 2836028.1)
Last updated on OCTOBER 02, 2023
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
Tiem Admin abends at Step TL_TA000501.XA000.Step060
Error Log:
-------------------------------------------------------------------------
PeopleTools 8.57.06 - Application Engine
Copyright (c) 1988-2021 Oracle and/or its affiliates.
All Rights Reserved
2021-11-09-09.46.58.000000: Starting TL_TIMEADMIN Core Time Administration App. (13507,13)
2021-11-09-09.46.58.000000: Starting TL_TA000200 Determine TRs To Process. (13507,13)
Reserved 2 Time Reporters for processing. (13507,8)
2021-11-09-09.46.58.000000: Starting TL_TA000300 Create Batches. (13507,13)
2021-11-09-09.46.59.000000: Starting TL_TA000400 Create Rule Maps. (13507,13)
2021-11-09-09.47.00.000000: Starting TL_TRPROFILE Get TR Profiles. (13507,13)
Batch 1 of 1 started. (13507,3015)
2021-11-09-09.47.02.000000: Starting TL_SCHRES_AE Schedule resolution. (13507,13)
If payable time is not created verify schedule set-up for Employee: 209148, 1 (13502,109)
2021-11-09-09.47.03.000000: Starting TL_TA000700 Create IPT. (13507,13)
2021-11-09-09.47.03.000000: Starting TL_TA_RULES TA Rules. (13507,13)
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 23 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_TL_IPT14"."CURRENCY_CD") to NULL
Failed SQL stmt: UPDATE PS_TL_IPT14 SET CURRENCY_CD=( SELECT PW.CURRENCY_CD FROM PS_TL_PROF_WRK4 PW WHERE PW.PROCESS_INSTANCE=:1 AND PW.EMPLID=PS_TL_IPT14.EMPLID AND PW.EMPL_RCD=PS_TL_IPT14.EMPL_RCD AND PS_TL_IPT14.DUR BETWEEN PW.EFFDT AND PW.END_EFFDT) WHERE PS_TL_IPT14.PROCESS_INSTANCE = :2 AND PS_TL_IPT14.CURRENCY_CD=' '
Process 3097212 ABENDED at Step TL_TA000501.XA000.Step060 (SQL) -- RC = 1407 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
-------------------------------------------------------------------------
STEPS TO RECREATE
-----------------------
1. Run Time admin
2. Process Abends
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |