Unable to enter dropship order with inactivated address (Doc ID 1954943.1)

Last updated on JULY 26, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem Description/Question:

When trying to process "Purchase Release" WF activity to Create Purchase Requisitions/Purchase Orders for Drop Ships, system is failing due to error
"There is no receiving location associated with this ship-to location.
Please define a receiving location in the Location form, then associate the two locations in the Customer form Address Business Purpose Detail window."
The error caused because the Ship To site on the sales order is inactivated, but this is done for a business reason.

The system should not have given this error.
This is a bug, as if user is allowed to created sales orders and book it with an inactivated address, that address should be accepted valid for processing for the entire life cycle of that sales order transaction.

The steps to reproduce the issue are :
1. Create a Sales Order for a given Customer
2. Select the appropriate header attributes/field values
3. Create a new SHIP TO for the chosen customer (using Add Customer feature)
4. Save the changes
5. Add Lines to the order
6. Set the Line Source Type to be EXTERNAL to Drop the products
7. Inactivate the SHIP TO selected above from Customer Master screen
8. Book the Order
9. The Order Line workflow will sit at "Purchase Release - Deferred" activity
10. Run the Workflow Background Process for Deferred as YES and Timeout as NO parameter value
11. Notice that the subsequent "Purchase Release" WF activity will not complete
12. Try to complete this activity via Order Lines > Action Button > Progress Order > "Purchase Release - Eligible" > press OK button
13. System will prompt the error message
"There is no receiving location associated with this ship-to location.
Please define a receiving location in the Location form, then associate the two locations in the Customer form Address Business Purpose Detail window."

Note: The same issue can be reproduced at will for any existing SHIP TOs - by disabling the SHIP TO site soon after it is added to the Order and changes are saved.

The issue caused in the "OE_OEOL_SCH.RELEASE_TO_PURCHASING" WF Function API as part of "Purchase Release" WF activity.
This failed because system expects the appropriate SHIP TO site in ACTIVE status. This is not correct.
Once a sales order is created for a valid SHIP TO and changes are saved, even if that SHIP TO is inactivated, still it should remain valid for processing for the entire life cycle of that sales order.
The same holds true several other business processes supported by Order Management.

--

We would like the order to process normally even with an inactivated address for a drop ship order, as it is doing for other order types.

For a regular sales order with inactive ship-to site we are able to process all transactions - book, pick, pack, ship, invoice and cash application.
The only transactions we are not able to process is creation of requisition for a drop ship order with inactive ship-to.
Is there a reason for allowing all other transactions on inactive ship-to but drop-ship PR/PO ?

The business requirement is usage of one-time address:
We have customers which ask us to ship items directly to their customers for items we outsource from our suppliers.
These temporary addresses are created on SO form by sales reps. and SO entered and inactivated to keep customer master clean.

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