ESS - Duplicate ESS Jobs in Running Mode

Published September 21, 2025 By Sai Sree Ram Gundepudi
SELECT COUNT(DEFINITION) AS COUNT, DEFINITION 
 FROM FUSION_ORA_ESS.request_HISTORY 
 WHERE STATE = 3 
 GROUP BY DEFINITION 
 HAVING COUNT(DEFINITION) > 20 
 ORDER BY 1 DESC; 
 

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article