Time Admin Throwing Unique Constraint Error At Step TL_SCHRES_AE.AA000.Step090
(Doc ID 2818723.1)
Last updated on JUNE 07, 2024
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 Reporting
Unable to submit time with Real-Time Rules or run Time Admin for a particular employee due to a unique constraint error. Step failing is due to SQL in TL_SCHRES_AE.AA000.Step090
While submitting time with Real-Time Rules:
PSAPPSRV.30632 (3985) 1-39722 10.22.55 0.001028 ErrorReturn-> 653 - CallAppEngine: Application TL_CALL_VAL: AppEngine error. (2,653) FUNCLIB_TL_WEEK.APPLY_RULES.FieldFormula Name:RunValidation PCPC:7367 Statement:69
Called from:TL_ENTER_TIME_FLU.GBL.SavePostChange Statement:5
PSAPPSRV.30632 (3985) 1-39723 10.22.55 0.000099 <<< end-ext Nest=354 RunValidation FUNCLIB_TL_WEEK.APPLY_RULES.FieldFormula Dur=0.477967 CPU=0.130000 Cycles=131
PSAPPSRV.30632 (3985) 1-39724 10.22.55 0.000006 <<< end Nest=353 TL_ENTER_TIME_FLU.GBL.SavePostChange Dur=0.480420 CPU=0.140000 Cycles=233
From Time Admin:
-- 11:42:44.528 Process 966565 ABENDED at Step TL_SCHRES_AE.AA000.Step090 (Action SQL) -- RC = 805
ROLLBACK
/
-- 11:42:44.852 SQL Error: ORA-00001: unique constraint (SYSADM.PS_WRK_ADHOC_TAO4) violated
The issue can be reproduced at will with the following steps:
1. Navigate to ESS fluid homepage > Time > Enter Time.
2. Submit time.
Or
1. Run Time Admin for the employee
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 |