My Oracle Support Banner

Error "SQLExec: 1 select list items in parameter list, but SQL has 0 select columns. (2,124)" When submitting Punchout Fluid eProcurement Requisition After Adding Requisition Header Comments (Doc ID 2876668.1)

Last updated on NOVEMBER 17, 2023

Applies to:

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

Symptoms

Getting error message when submitting an ePro fluid requisition after punching out to supplier website then adding a header comments.




The issue can be reproduced at will with the following steps:

  1. Navigate to Home Page > eProcurement tile > Create requisition tile and create a new requisition
  2. Click on Web supplier tab and punchout to supplier web site then add any item
  3. Checkout from supplier website back to the PS application.
  4. Press on Item description hyperlink then click save .
  5. Press on Requisition header comments and add any comment then press on Save.
  6. Try to submit the requisition.
  7. Getting error message.


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.