DC Purchase Order Dispatch ABENDED At Step PO_DISPATCH.EDX.Step01

(Doc ID 1664093.1)

Last updated on MAY 21, 2018

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.1 and later
Information 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

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