EAP: Matching Process Abended with "SQLExec: 1 Select :ist Items in Parameter List, But SQL has 0 Select Columns. (2,124)" Error at Step AP_MATCH.MAIN.Step05 (PeopleCode) When Run for Match Action 'Matching & Workflow/Email' (Doc ID 1930635.1)

Last updated on MARCH 18, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

AP Matching (AP_MATCH) abended at step AP_MATCH.MAIN. GBL.default.1900-01-01.Step05.OnExecute with the following error message:
SQLExec: 1 select list items in parameter list, but SQL has 0 select columns. (2,124).

Steps:
--------
1. Navigate to Accounts Payable > Batch Processes > Vouchers > Matching.
2. Select Match Action = 'Match Action 'Matching & Workflow/Email'.
3. Select Options ='Business Unit'
4. Run the process

Error:
-------
SQLExec: 1 select list items in parameter list, but SQL has 0 select columns. (2,124).

 

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