Last updated on MAY 05, 2017
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On : 9.2 version, PUM 21
The Time and Labor Dashboard's Absence Request Pagelet is throwing an error while loading.
SQL.Fetch: 42 items in parameter list, but SQL has 40. (2,293) TL_COMMON.EmployeeList.GetEmployees.OnExecute Name:BuildOnPageRowset PCPC:6851 Statement:148
Called from:TL_COMMON.EmployeeList.GetEmployees.OnExecute Name:EmployeeList Statement:112
Called from:FUNCLIB_TL_CP.MGR_SS_FUNC.FieldFormula Name:PrepToLoadEmployees Statement:773
Called from:HGA_MGR_APPV.AbsenceRequests.ComponentControls.Events.OnExecute Name:ComponentPostBuild Statement:16
Called from:HGA_ABS_PGLT.GBL.PostBuild Statement:
The wrong number of parameters were supplied to the Fetch method of an SQL object.
The issue can be reproduced at will with the following steps:
1. Log in to application as RCHANNING or PS
2. Main Menu - Manager Self Service - Time Management - Time and Labor Dashboard
3. Add Absence Request pagelet if it's not in your view.
4. Error will show up when loading the pagelet.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms