ETL9.X: Submitted absence can be edited on timesheet causes Fatal (2,125) SQL error.
(Doc ID 1921026.1)
Last updated on APRIL 01, 2019
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
When a self service absence request is edited on the timesheet, the following
error is produced:
FATAL SQL ERROR OCCURRED (2, 125) FUNCLIB_GP_ABS.ABS_TL_FUNCTIONS
FieldFormula Name AbsTLSS_SavePreChng PCPC:93427 Statement:825 Called
from:DERIVED_ABS_SS.ADD_PB SavePreChange Statement 6.
STEPS TO REPLICATE
1. Sign on to system as employee. Navigate Self Service > Time Reporting > Report Time>Absence Request.
2. Enter absence and submit (Manager has NOT yet approved and this absence has not gone through any of the absences processes, thus is in the status of 'submitted'.
3. Now, again as employee, navigate Self Service>Time Reporting>Report Time>Timesheet. This absence request is visible and the edit button is available
4. Check the 'cancel' check box and hit the edit button. The timesheet allows for the ability to (apparently) edit this event, but when the 'submit' button is chosen, receive the fatal sql error as listed in description.
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