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

Last updated on APRIL 05, 2016

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 .


Verified the issue in the log file as noted below:

LOG FILE
Filename = wfmlrdbg53125.html

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'.






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