Change Management Drop Ship: How to Update Promise Date on PO to Sales Order (Doc ID 403607.1)

Last updated on OCTOBER 01, 2024

Applies to:

Goal

For Drop Ship Orders, one wants the ability to update the Customer Order Promise Date field from the corresponding Promise Date field on the Purchase Order as the Supplier changes the date.

One is using the Oracle Drop Ship functionality; this is where one orders an external item and then runs the Requisition Import to generate a Purchase Order for this item to be sent to the Supplier. The Suppliers receive the PO from our iSupplier Portal.

If the supplier changes the Promise Date on the Portal, this is passed and accepted by the Buyer, this is then updated on the Purchase Order and PO is Re-Approved.
One wants this date change to automatically be passed back to the corresponding Customer Order to update the Promise Date field on the Order Line Table (oe_order_lines_all.promise_date).

If one makes a change to the Purchase Order, should a window pop-up that notes this PO is tied to a Customer Order?
When one changes any data on the Customer Order and re-books the order, one receives a message that the Order is tied to a Purchase Order; however, one is not receiving this message when one updates the PO.


This document advises if there is functionality to do either of these (Update Promise Date on Order from change made to corresponding Promise Date on Drop Ship Purchase Order, and/or have Pop-Up Window on Purchase Order appear when a change is
made to the PO to note that this is linked to the Customer Order). This document addresses the question "Does this functionality exist today"?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.