My Oracle Support Banner

Workflow Notifications -Ora-20002: 2018: Unable To Generate The Notification Xml (Doc ID 364149.1)

Last updated on MAY 18, 2024

Applies to:

Oracle Workflow - Version 11.5.9 to 11.5.10.2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.

Symptoms

On 11.5.9 in Production:
Numerous errored workflows are received,
and the following error occurs.

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-06502: PL/SQL: numeric or value error

wf_notification.GetAttrDoc2(53169, ORDERFOOTER, text/plain)
Wf_Notification.GetAttrDoc(53169, ORDERFOOTER, text/plain)
Wf_Notification.GetText(53169, text/plain)
Wf_Notification.GetBody(53169, text/plain)
WF_NOTIFICATION.GetFullBody(nid => 53169, disptype => text/plain)
WF_MAIL.GetLOBMessage3(nid => 53169, r_ntf_pref => MAILTEXT)' encountered
during execution of Generate function 'WF_XML.Generate' for event
'oracle.apps.wf.notification.send'.
Event Error Stack:
WF_MAIL.GetLOBMessage3(53169, WFPROD, 2020: Error when getting notification
content. Caused by: ORA-06502: PL/SQL: numeric or value error


The issue has the following business impact:
Due to this issue, notifications are failing to generate the Notification XML .



See the following error for the notification:

3835: Error '-6508 - ORA-06508: PL/SQL: could not find program unit being called' encountered
during execution of Generate function 'WF_XML.Generate' for event
'oracle.apps.wf.notification.send'.






Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.