Interface Trip Stop (WSHINTERFACES) Stays Running For a Long Time Intermittently
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.
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.
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