Interface Trip Stop Hangs Intermittently (Doc ID 1333008.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Oracle Shipping Execution - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

When running the Interface Trip Stop (ITS), occasionally the ITS process hangs. The following statement as shown in the raw trace file is followed by hundreds of WAIT statements over a 2 hour time period:

 
Expected behavior:
System should not hang on this autonomous transaction. ITS should finish within a few minutes. Due to this issue, users occasionally cannot complete the Interface Trip Stop. The user must kill the ITS process and restart it to recover.

Steps:
1. Execute the Interface Trip Stop for any delivery or trip stop.
2. ITS appears to hang; it never completes, user then kills the process.

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