0 Replies Latest reply on Jan 28, 2016 5:17 PM by 2771277

    scripting workflow status on older EBS (11.5.7)

    2771277

      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.