ETL92: Payable Time Error - SQL.Fetch: 5 Items In Parameter List, But SQL Has 8
(Doc ID 3041623.1)
Last updated on FEBRUARY 03, 2025
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
The following Payable Time Error message is triggered when navigating to next employee:
Error:
SQL.Fetch: 5 items in parameter list, but SQL has 8.
TL_TIME_VIEW.PayableTime.OnExecute Name:PopulatePayableTime PCPC:1187 Statement:21
Called from:TL_MSSCH_FL_WRK.NEXT_EMPL.FieldChange Statement:182
The wrong number of parameters were supplied to the Fetch method of an SQL object.
Steps to Recreate:
1. Login as PS using navigation MSS> Team Time> Payable Time.
2. Select the first employee.
3. On the payable time page, select FROM = 1/1/24.
4. Press the Details tab.
5. Press NEXT to go to the next employee.
6. Note: Above error is triggered.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |