ETL9.X: Submitted absence can be edited on timesheet causes Fatal (2,125) SQL error.
Last updated on JANUARY 05, 2018
Applies to:PeopleSoft Enterprise HRMS 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
3. Now, again as employee, navigate Self Service>Time Reporting>Report Time>Timesheet. This absence request is visible and the edit button is
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, recieve the fatal sql error as listed in description.
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