Interface Trip Stop (WSHINTERFACES) Stays Running For a Long Time Intermittently
(Doc ID 2420103.1)
Last updated on JUNE 07, 2021
Applies to:Oracle Shipping Execution - Version 12.2.6 and later
Information in this document applies to any platform.
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 Application Technology (ATG) team to see if there were any locks in the environment 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 intermittent issue and unfortunately it cannot be reproduced in a Test instance.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document