workflow purchasing error..
Event Error Name: WFE_DISPATCH_GEN_ERR
Event 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-20002: 3240: Error '-4061 - ORA-04061:
existing state of has been invalidated
ORA-04061: existing state of package body "APPS.POS_GET" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.POS_GET"
' in 'PLSQLCLOB' API 'PO_WF_PO_NOTIFICATION.GET_PO_LINES_DETAILS'
Wf_Notification.GetAttrClob(5084773, PO_LINES_DETAILS, text/html)
Wf_Notification.old' encountered during execution of Generate function 'WF_XML.Generate' for event
'oracle.apps.wf.notification.send'.
Event Error Stack:
WF_MAIL.GetLOBMessage4(5084773, WFMAIL, 2020: Error when getting notification content. Caused by: ORA20002: 3240: Error '-4061 - ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package body "APPS.POS_GET" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.POS_GET"
Solution:
We need to perform below and check if still we are getting issue..
1. Shutdown workflow along with container..
2. Recompile the APPS schema through ADADMIN
3. Start the workflow mailer..
If still issue after above action plan then, we need to stop and start whole applications...
