Supply Chain Management - PSFT (MOSC)

MOSC Banner

PO DISPATCH Program is Failing with Duplicate Error when dispatching a DropShip PO..

edited Feb 28, 2013 9:47AM in Supply Chain Management - PSFT (MOSC) 8 commentsAnswered

Hello , has anyone experienced this Problem, in Peoplesoft 9.1

PO Dispatch Process (PO_XMLP) is failing when you try to dispatch a DROPSHIP PO which has the same ORDER_INT_LINE_NO on 2 or more PO Lines in PS_PO_LINE_SHIP Table.

Example :

When a Salea ORDER SO123 having ORDER_INT_LINE_NO = 1 , qty of 10 is sourced to 2 different PO LINES on a PO ( Split ito 2 different PO Lines on the same PO)

SALE ORDER # = SO123

ORDER_INT_LINE_NO = 1

QTY = 10

Created the below PO.

PO # = PO123

Line_nbr = 1 , qty = 4 , PO_LINE_SHIP.ORDER_INT_LINE_NO = 1

Line_nbr = 2, qty = 6 , PO_LINE_SHIP.ORDER_INT_LINE_NO = 1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center