DC Purchase Order Dispatch ABENDED At Step PO_DISPATCH.EDX.Step01
(Doc ID 1664093.1)
Last updated on NOVEMBER 23, 2019
Applies to:
PeopleSoft Enterprise SCM eProcurement - Version 9.1 and laterInformation in this document applies to any platform.
Symptoms
On : 9.1 version, Manage Purchase Orders
When attempting to dispatch a direct connect PO
the following error occurs.
ERROR
-----------------------
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
STEPS
-----------------------
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
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 |