Purchase Order Workflow Fails with ERROR_MESSAGE=3835: ORA-20002: 2018: Unable To Generate The Notification XML and ORA-6502 (Doc ID 754600.1)

Last updated on SEPTEMBER 23, 2022

Applies to:

Symptoms

In Oracle Purchasing, PO approval workflow completes with the following error when the approver's email style is set as Plain Text with HTML:

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-06502: PL/SQL: numeric or value error WF_NOTIFICATION.WriteToClob() Wf_Notification.GetAttrClob(620966, PO_LINES_DETAILS, text/plain) Wf_Notification.oldGetAttrClob(620966, PO_LINES_DETAILS, text/plain) WF_NOTIFICATION.GetFullBody(nid => 620966, disptype => text/plain) WF_MAIL.GetLOBMessage3(nid => 620966, r_ntf_pref => MAILATTH)' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'.

ERROR_STACK=

WF_MAIL.GetLOBMessage3(620966, WFMAIL, 2020: Error when getting notification content. Caused by: ORA-06502: PL/SQL: numeric or value error WF_NOTIFICATION.WriteToClob() Wf_Notification.GetAttrClob(620966, PO_LINES_DETAILS, text/plain) Wf_Notification.oldGetAttrClob(620966, PO_LINES_DETAILS, text/plain) WF_NOTIFICATION.GetFullBody(nid => 620966, disptype => text/plain) WF_MAIL.GetLOBMessage3(nid => 620966, r_ntf_pref => MAILATTH), Step -> Getting text/plain body) WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 620966) WF_XML.Generate(oracle.apps.wf.notification.send, 620966) WF_XML.Generate(oracle.apps.wf.notification.send, 620966) Wf_Event.setMessage(oracle.apps.wf.notification.send, 620966, WF_XML.Generate) Wf_Event.dispatch_internal()

.

Changes

Cause

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