Using OE_ORDER_PUB.PROCESS_ORDER API a booked order has delivery details but no delivery
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.