My Oracle Support Banner

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.

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

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
References


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