Order Management - EBS (MOSC)

MOSC Banner

Using OE_ORDER_PUB.PROCESS_ORDER API a booked order has delivery details but no delivery

edited Apr 28, 2017 5:00AM in Order Management - EBS (MOSC) 1 commentAnswered

Hi All,

I have pl/sql that uses the process_order_api and will book the order.

But when I try and execute a 'PICK-RELEASE' the error I get is invalid delivery name.

When I look I see there are delivery details, I get a delivery_detail_id and there are the required records in wsh_delivery_details table.

But there is no delivery associated with the order

the table wsh_delivery_assignments does not have a record with the deliver_id and delivery_detail_id for this order.

I am trying to use the WSH_DELIVERY_DETAILS_PUB.Detail_to_Delivery to assign the details to a delivery, but I don't know what to put into the p_TabOfDelDet(1) input.

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