Shipping Execution - EBS (MOSC)

MOSC Banner

Actual shipment error in Shipping-Transportation outbound interface - Child

edited Jan 24, 2017 8:48AM in Shipping Execution - EBS (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center