Interface Trip Stop (WSHINTERFACES) Stays Running For a Long Time Intermittently

(Doc ID 2420103.1)

Last updated on JULY 06, 2018

Applies to:

Oracle Shipping Execution - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Interface Trip Stop


The Interface Trip Stop concurrent program is scheduled to run every 10 minutes.
Sometimes, for unknown reason, the concurrent stays running for a long time.
We need to cancel the execution.

Asked ATG team to see if there were any locks in the enviroment in that moment, but no lock was found.
They just identified that the concurrent was running with the following query :
  SELECT NVL(MO_GLOBAL.GET_CURRENT_ORG_ID,0) FROM DUAL,

It also looks like that the concurrent was waiting for something.


This is a intermitent issue and unfortunately it cannot be reproduced in a Test instance.


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