WSHINTERFACES Fails With Invalid Location Error (Doc ID 865703.1)

Symptoms

On 11.5.10 CU2 in Production:
When attempting to interface a delivery to inventory the following error occurs.

The record in HZ does have a date in the last_update_date, but it is not importing into WSH.  To verify this issue, run the following sql:

select wsh_location_id, source_location_id, location_source_code
from wsh_locations where source_location_id = xxxxxx ;

select * from hz_locations where location_id = xxxxxx ;


If the sql does not return any rows, then the location ids are not in WSH tables, causing ITS to fail.

ERROR
P_MODULE_NAME ==> wsh.plsql.WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV
msg_buffer ==> Invalid location

STEPS
The issue can be reproduced at will with the following steps:
1. Using the OM Super User Responsibility, navigate to Shipping> Interfaces> Interface TripStop.
2. Using the delivery or trip stop id, run the process.
3. Process fails with the errors.

Cause

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