Error "ORA-20002: 2018: Unable to generate the notification XML" When OM Approval Notification Mails are Sent

(Doc ID 2319998.1)

Last updated on OCTOBER 23, 2017

Applies to:

Oracle Order Management - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Workflow Mailer

OM Quote approval notifications are not sent via email, only Worklist notifications are seen.

From the output of the wfmlrdbg.sql, the following Errors were displayed.

ERROR
-----------------------

Error Message 3835: Error '-20002 - ORA-20002: 2018: Unable to generate the notification XML. Caused by: 2020: Err or when getting notification content. Caused by: ORA-04061: existing state of has been invalidated ORA-04061: existing state of package body "APPS.OE_ORDER_WF_UTIL" has been invalidated ORA-04065: not executed, altered or dropped package body "APPS.OE_ORDER_WF_UTIL" ORA-06508: PL/SQL: could not find program unit being called: "APPS.OE_ORDER_WF_UTIL" wf_notification.GetAttrDoc2(11676350, NEGOTIATION_DETAILS, text/html) Wf_Notif' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps .wf.notification.send'.

Error Stack WF_MAIL.GetLOBMessage3(11676350, WFMAIL, 2020: Error when getting notification content. Caused by: O RA-04061: existing state of has been invalidated ORA-04061: existing state of package body "APPS.OE_ORDER_WF_UTIL" has been invalidated ORA-04065: not executed, altered or dropped package body "APPS.OE_ORDER_WF_UTIL" ORA-06508: PL/SQL: could not find program unit being called: "APPS.OE_ORDER_WF_UTIL" wf_notification.GetAttrDoc2(11676350, NEGOTIATION_DETAILS, text/html) Wf_Notification.GetAttrDoc(11676350, NEGOTIATION_DETAILS, text/html) Wf_Notification.GetText(11676350, text/html) Wf_Notification.GetBody(11676350, text/html) WF_NOTIFICATION.GetFullBody(nid => 11676350, disptype => text/html) WF_MAIL.GetLOBMessage3(nid => 11676350, r_ntf_pref => MAILHTML), Step -> Getting text/html body) WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 11676350) WF_XML.Generate(oracle.apps.wf.notification.send, 11676350) WF_XML.Generate(oracle.apps.wf.notification.send, 11676350) Wf_Event.setMessage(oracle.apps.wf.notification.send, 11676350, WF_XML.Generate) Wf_Event.dispatch_internal()

STEPS
-----------------------
- Quote has been approved.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms