Tuesday, September 3, 2013

ORA-04061: existing state of package body “XXXX” has been invalidated

[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.XX_CHANGE_REQUEST_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.XXI_CHANGE_REQUEST_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.XX_CHANGE_REQUEST_PKG"

Wf_Notification.GetAttrClob(2836675, XX_NOTIFICAT' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK=
WF_MAIL.GetLOBMessage3(2836675, PRDMAIL, 2020: Error when getting notification content. Caused by: ORA-04061: existing state of  has been invalidated
ORA-04061: existing state of package body "APPS.XX_CHANGE_REQUEST_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.XX_CHANGE_REQUEST_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.XX_CHANGE_REQUEST_PKG"

Wf_Notification.GetAttrClob(2836675, XX_NOTIFICATION_MESSAGE, text/html)
Wf_Notification.oldGetAttrClob(2836675, XX_NOTIFICATION_MESSAGE, text/html)
WF_NOTIFICATION.GetFullBody(nid => 2836675, disptype => text/html)
WF_MAIL.GetLOBMessage3(nid => 2836675, r_ntf_pref => MAILHTML), Step -> Getting text/html body)
WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 2836675)
WF_XML.Generate(oracle.apps.wf.notification.send, 2836675)
WF_XML.Generate(oracle.apps.wf.notification.send, 2836675)
Wf_Event.setMessage(oracle.apps.wf.notification.send, 2836675, WF_XML.Generate)

Wf_Event.dispatch_internal()

--For the above issue the below solution worked for us.

A bounce of Workflow and Mailer Services

The below reference helped


1 comment:

Unknown said...

I am Sridevi Koduru, Senior Oracle Apps Trainer With 8 Yrs Exp on Oracle Apps and 13 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K. I have Provided Training for 500+ Professionals Most of them are Working in Real Time now.

Contact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Financial for Indian Localization, Oracle Apps SCM, Oracle Apps HRMS, SQL, PL/SQL and D2K at training@oracleappstechnical.com or sridevikoduru@oracleappstechnical.com | +91-9581017828 | http://www.oracleappstechnical.com

Linkedin profile - http://in.linkedin.com/pub/sridevi-koduru/8b/76a/9b8/