Actual shipment error in Shipping-Transportation outbound interface - Child
Hi,
The concurrent program Shipping-Transportation outbound interface - Child is getting failed.
The trip is closed in oracle and the status of tms_interface_flag in trip in wsh_trip_stops is 'ASR' means actaul shipment is required to OTM from oracle.
The error message shows it is getting authentication failed because it wants to run a query
select distinct wt.trip_id, wt.name from wsh_trip_stops wts, wsh_trips wt where wts.tms_interface_flag = 'ASP' and wt.trip_id = wts.trip_id and wt.trip_id between :1 and :2
Ids Picked up 1
7053471 Hash Table Entry 7053471
.
How can I check and what data fix can we apply on this so that this trip will be picked by the concurrent program.