ETL9.X: Submitted absence can be edited on timesheet causes Fatal (2,125) SQL error. (Doc ID 1921026.1)

Last updated on JUNE 15, 2016

Applies to:

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

Symptoms

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, recieve the fatal sql error as listed in description.

Cause

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