My Oracle Support Banner

Time Admin Throwing Unique Constraint Error At Step TL_SCHRES_AE.AA000.Step090 (Doc ID 2818723.1)

Last updated on DECEMBER 22, 2022

Applies to:

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


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
-- 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.


1. Run Time Admin for the employee


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.