I'm attempting to script a process to notify me if oracle workflow has crashed or otherwise gone down. I've used the following for R12.1:
select COMPONENT_STATUS from APPS.FND_SVC_COMPONENTS where COMPONENT_ID=10006;
the FND_SVC_COMPONENTS Table is not available in 11.5.7, and all applsys related wf tables have a status of "enabled" or "disabled", which won't capture a "failed" state. Does anyone know if there's any wf or conc views I could use to gather information for a similar purpose? This edition of EBS is very old, and I'm not familiar with all the objects.