Re: Workflow Error Agent Listener agent(Automatic component) frequently going to system deactivated status

Posted by ErmanArslansOracleBlog on Jul 16, 2018; 6:49am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Workflow-Error-Agent-Listener-agent-Automatic-component-frequently-going-to-system-deactivated-status-tp6412p6417.html

If your TEMP tablespace is fine .(have the required free space all the time + not corrupted), then you are probably hitting a bug..

It may be a compilation issue as well.. ( Workflow does not recommend any specific type either NATIVE or INTERPRETED)

Please check the following document->

Workflow Notification Agent Listeners Fail with unhandled user-defined exception ORA-06512: at "APPS.WF_EVENT" (Doc ID 1066568.1)

I still recommend you to "recreate" your TEMP tablespace, restart your database and apps services and retry... (just in case)