Coba dicek, apakah procedure APPS.TSELXX_STPD_WF nya VALID atau INVALID... SQL> select owner, object_name, status from dba_objects where object_name = 'TSELXX_STPD_WF';
bw --- In [email protected], dany fauzi <rewind_d...@...> wrote: > > Pada oracle2 master sekalian,ada yang pernah dapetin error workflow kyk gini > gak,boleh kalo tau memberikan pencerahan..terima kasih > ======================= > Failed Activity TSEL XX STPD Notify Submitter > > 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 "APPS.TSELXX_STPD_WF" has > been > invalidated ORA-04065: not executed, altered or dropped package > "APPS.TSELXX_STPD_WF" ORA-06508: PL/SQL: could not find program unit being > called wf_notification.GetAttrDoc2(3392609, ZMSG_BODY_DOC, text/html) > Wf_Notification.GetAttrDoc(3392609, ZMSG_BODY_DOC, tex' encountered during > execution of Generate function 'WF_XML.Generate' for event > 'oracle.apps.wf.notification.send'. ERROR_STACK= > WF_MAIL.GetLOBMessage3(3392609, > WFMAIL, 2020: Error when getting notification content. Caused by: ORA-04061: > existing state of has been invalidated ORA-04061: existing state of package > "APPS.TSELXX_STPD_WF" has been invalidated ORA-04065: not executed, altered > or > dropped package "APPS.TSELXX_STPD_WF" ORA-06508: PL/SQL: could not find > program > unit being called wf_notification.GetAttrDoc2(3392609, ZMSG_BODY_DOC, > text/html) > Wf_Notification.GetAttrDoc(3392609, ZMSG_BODY_DOC, text/html) > Wf_Notification.GetText(3392609, text/html) Wf_Notification.GetBody(3392609, > text/html) WF_NOTIFICATION.GetFullBody(nid => 3392609, disptype => text/html) > WF_MAIL.GetLOBMessage3(nid => 3392609, r_ntf_pref => MAILHTML), Step -> > Getting > text/html body) WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 3392609) > WF_XML.Generate(oracle.apps.wf.notification.send, 3392609) > WF_XML.Generate(oracle.apps.wf.notification.send, 3392609) > Wf_Event.setMessage(oracle.apps.wf.notification.send, 3392609, > WF_XML.Generate) > Wf_Event.dispatch_internal() > > > Error Stack > > > > ===================== > > > > [Non-text portions of this message have been removed] >
