Error in Shipping-Transportation outbound interface - Child

Hi,

When 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

.

Although others trip are processed and sent to oracle and TMS_INTERFACE_FLAG gets changed.