ETL9.2: Time And Labor Dashboard - Absence Request Pagelet Received Error

(Doc ID 2252165.1)

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.

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

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