State at Notification, changes to error after few minutes.
I am new to oracle workflow, please give me some idea why this is happening. After the workflow is triggered, I can see it via status monitor marked as 'Active', and I can see the notification but after few minutes it turns to 'Error'.
Why is this happening?
clicking the 'Error' displays this:
Failed Activity FOR_ENDORSE_CLEARANCE_FORM_NTF
Activity Type Notice
Error Name WF_ERROR
Error Message
[WF_ERROR] ERROR_MESSAGE=3835: Error '-20002 - ORA-20002: 2018: Unable to generate the notification XML. Caused by: 2020: Error when getting notification content. Caused by: ORA-04061: existing state of has been invalidated ORA-04061: existing state of package body "APPS.ABC_PA_CPS_WF" has been invalidated ORA-04065: not executed, altered or dropped package body "APPS.ABC_PA_CPS_WF" ORA-06508: PL/SQL: could not find program unit being called: "APPS.ABC_PA_CPS_WF" wf_notification.GetAttrDoc2(2022278, DOCUMENT_NOTATION, text/html) Wf_Notification.GetA' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK= WF_MAIL.GetLOBMessage3(2022278, WFMAIL, 2020: Error when getting notification content. Caused by: ORA-04061: existing state of has been invalidated ORA-04061: existing state of package body "APPS.ABC_PA_CPS_WF" has been invalidated ORA-04065: not executed, altered or dropped package body "APPS.ABC_PA_CPS_WF" ORA-06508: PL/SQL: could not find program unit being called: "APPS.ABC_PA_CPS_WF" wf_notification.GetAttrDoc2(2022278, DOCUMENT_NOTATION, text/html) Wf_Notification.GetAttrDoc(2022278, DOCUMENT_NOTATION, text/html) Wf_Notification.GetText(2022278, text/html) Wf_Notification.GetBody(2022278, text/html) WF_NOTIFICATION.GetFullBody(nid => 2022278, disptype => text/html) WF_MAIL.GetLOBMessage3(nid => 2022278, r_ntf_pref => MAILHTML), Step -> Getting text/html body) WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 2022278) WF_XML.Generate(oracle.apps.wf.notification.send, 2022278) WF_XML.Generate(oracle.apps.wf.notification.send, 2022278) Wf_Event.setMessage(oracle.apps.wf.notification.send, 2022278, WF_XML.Generate) Wf_Event.dispatch_internal()