Some Workflows Failing With 2020: Error when getting notification content. Caused by: ORA-06533: Subscript beyond count (Doc ID 2206116.1)

Last updated on NOVEMBER 21, 2016

Applies to:

Oracle Workflow - Version 12.1.1 to 12.2.3 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On Oracle Applications 12.1.1, Workflow Mailer,
some workflows ending with "Complete with Errors" status because exists a notification ending with "ERROR" mail status.

These notifications have a attachment file, they are almost always the same, but not always fail, sometimes end normally.

[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-06533: Subscript beyond count
Wf_Notification.GetAttrClob(1555236, PO_LINE_LOCATIONS_DETAILS, text/html)
Wf_Notification.oldGetAttrClob(1555236, PO_LINE_LOCATIONS_DETAILS, text/html)
WF_NOTIFICATION.GetFullBody(nid => 1555236, disptype => text/html)
WF_MAIL.GetLOBMessage3(nid => 1555236, r_ntf_pref => MAILHTML)' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK= WF_MAIL.GetLOBMessage3(1555236, WFMAIL, 2020: Error when getting notification content. Caused by: ORA-06533: Subscript beyond count
Wf_Notification.GetAttrClob(1555236, PO_LINE_LOCATIONS_DETAILS, text/html)
Wf_Notification.oldGetAttrClob(1555236, PO_LINE_LOCATIONS_DETAILS, text/html)
WF_NOTIFICATION.GetFullBody(nid => 1555236, disptype => text/html)
WF_MAIL.GetLOBMessage3(nid => 1555236, r_ntf_pref => MAILHTML), Step -> Getting text/html body) WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 1555236) WF_XML.Generate(oracle.apps.wf.notification.send, 1555236)
WF_XML.Generate(oracle.apps.wf.notification.send, 1555236) Wf_Event.setMessage(oracle.apps.wf.notification.send, 1555236, WF_XML.Generate) Wf_Event.dispatch_internal()


The issue can be reproduced at will with the following steps:
1. Generate email notifications.

The issue has the following business impact:
Due to this issue, some workflow email notifications cannot be processed.

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