1 Reply Latest reply on Feb 3, 2017 6:46 PM by User910243567

    Error in PO Workflow while sending the Approved notification

    Ankit.Bang-Oracle

      Hi,

       

      We have customized the PO Approval Workflow to send the approved email with the attachments(PDF) and to send it to the requester instead of Buyer. However sporadically we encounter the issues where the email notifications fails.

       

      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-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(1391895, PO_LINES_DETAILS, text/html) Wf_Notification.old' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK= WF_MAIL.GetLOBMessage4(1391895, WFMAIL, 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(1391895, PO_LINES_DETAILS, text/html) Wf_Notification.oldGetAttrClob(1391895, PO_LINES_DETAILS, text/html) WF_NOTIFICATION.GetFullBody(nid => 1391895, disptype => text/html) WF_MAIL.GetLOBMessage4(nid => 1391895, r_ntf_pref => MAILHTML), Step -> Getting text/html body) WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 1391895) WF_XML.GenerateGroupDoc(oracle.apps.wf.notification.send, 1391895) WF_XML.Generate(oracle.apps.wf.notification.send, 1391895) WF_XML.Generate(oracle.apps.wf.notification.send, 1391895) Wf_Event.setMessage(oracle.apps.wf.notification.send, 1391895, WF_XML.Generate) Wf_Event.dispatch_internal()

       

      We have cleared the shared pool, start the mailer and compiled the DB but still this issue is reoccurring. Any pointer towards how to further debug or resolve this would be helpful

       

      Thanks,

      Ankit