My Oracle Support Banner

ETL9.2: Time And Labor Dashboard - Absence Request Pagelet Received Error (Doc ID 2252165.1)

Last updated on JUNE 30, 2020

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

On : 9.2 version, PUM 21

The Time and Labor Dashboard's Absence Request Pagelet is throwing an error while loading.


ERROR
-----------------------
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.


STEPS
-----------------------
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.

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.