Interface Trip Stop Hangs Intermittently
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 22.214.171.124 to 126.96.36.199 [Release 11.1 to 11.2]
Information in this document applies to any platform.
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:
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms