My Oracle Support Banner

ETL9.2: On Fluid Time Summary Page Sql Error Occurred When FS ACITIVITY is used (Doc ID 2508048.1)

Last updated on NOVEMBER 14, 2019

Applies to:

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

Symptoms

When attempting to open Time Summary page, the following error occurs.

ERROR
-----------------------
Fatal SQL error occurred. (2,125)

TL_TIME_SUMMARY.TimesummaryDisplay.OnExecute Name:buildTimedtlstring PCPC:60043 Statement:838
Called from:TL_TIME_SUMMARY.TimesummaryDisplay.OnExecute Name:getTimeDetails Statement:769
Called from:TL_TIME_SUMMARY.TimesummaryDisplay.OnExecute Name:displayTimesumFooter Statement:583
Called from:TL_TIME_SUMMARY.TimesummaryDisplay.OnExecute Name:loadTimeSummary Statement:416
Called from:TL_TIME_SUM_FLU.GBL.TL_ELP_TIME_WRK.TL_VIEW_DATE.FieldChange Statement:5


STEPS
-----------------------
1. Navigate to Fluid Employee Self Service > Time > Enter Time, report and submit time for the employee by populating Business Unit PF and Activity Id
2. Now Click on Time Summary, click on the date to select a previous period date.

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.