E-MSSQL: The Wrong Number Of Parameters Were Supplied To The Fetch Method Of An SQL Object (Doc ID 2269958.1)

Last updated on MAY 25, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.

Symptoms

9.2 > Tools 8.53

ISSUE:
Error received through Voucher Inquiry

ERROR:
SQL.Fetch: 45 items in parameter list, but SQL has 0. (2,293) AP_VCHR_INQ_VW.BUSINESS_UNIT.FieldFormula Name:SearchExeStatement PCPC:41195 Statement:583
Called from:AP_VCHR_INQ.GBL.AP_VCHR_INQ_WRK.SEARCH_BUTTON.FieldChange Statement:228
The wrong number of parameters were supplied to the Fetch method of an SQL object

STEPS:
Accounts Payable > Review Accounts Payable Info > Vouchers > Voucher
BU From / To = BERKC
Voucher ID From / To = 00425853
Supplier SetID = BERKC

BUSINESS IMPACT:
Unable to use Voucher Inquiry

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