Last updated on DECEMBER 14, 2016
Applies to:PeopleSoft Enterprise SCM eProcurement - Version 9.1 and later
Information in this document applies to any platform.
On : 9.1 version, Manage Purchase Orders
When attempting to dispatch a direct connect PO
the following error occurs.
SQLExec: 16 select list items in parameter list, but SQL has 17 select columns. (2,124) PO_DISPATCH. Utilities.LinkedSupplierData.OnExecute Name:setBillAddress PCPC:4199 Statement:75 Called from:SCM_PV_PO_DISPATCH.PurchaseOrder.OnExecute Name:setHeaderMsgData Statement:87 Called from:SCM_PV_PO_DISPATCH.CxmlPurchaseOrder.OnExecute Name:XMLPDispatch Statement:383 Called from:PO_DISPATCH.PO_Dispatch_EDX_Dynamic.OnExecute Name:dispatch Statement:34 Called from:PO_DISPATCH.PO_Dispatch_EDX_ALL.OnExecute
The issue can be reproduced at will with the following steps:
1. Setup DC for Requisition and Dispatch
2. build a req and source to EDX PO
3. Try to dispatch the resulting EDX PO
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms