Unable To Generate The Notification XML In Online Discussion getting ora-20002: 3240: error '-6502 error in ponauct notification

(Doc ID 2141656.1)

Last updated on DECEMBER 20, 2017

Applies to:

Oracle Sourcing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In Oracle SOURCING, for an RFQ during Online Discussion with Supplier, the Notification shows the following error.


ERROR
-----------------------
The Error message is like:
An Error occurred in the following Workflow.

Item Type = PONAUCT
Item Key = 16001-16015-630971
User Key =

Error Name = WF_ERROR
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-20002: 3240: Error '-6502 - ORA-06502: PL/SQL: numeric or value error: character string buffer too small
' in 'PLSQLCLOB' API 'PON_AUCTION_PKG.GET_DISCUSSION_MESG_BODY'

Wf_Notification.GetAttrClob(1984257, DISCUSSION_MESSAGE_BODY, text/html)
Wf_Notification.oldGetAttrClob(1984257, DISCUSSION_MESSAGE_BODY, text/html)
WF_NOTIFICATION.GetFullBody(nid => 1984257, disptype => text/h' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK=
WF_MAIL.GetLOBMessage4(1984257, WFMAIL, 2020: Error when getting notification content. Caused by: ORA-20002: 3240: Error '-6502 - ORA-06502: PL/SQL: numeric or value error: character string buffer too small
' in 'PLSQLCLOB' API 'PON_AUCTION_PKG.GET_DISCUSSION_MESG_BODY'




STEPS
-----------------------

1. Login to Sourcing super user
2. Find existing RFQ 300652 that has a quote from supplier
3. Click quote# in response
4. Click Online Discussions
5. Click New message
6. Paste the content from file Sample_Data_Failure.txt
7. Submit
8. Login as supplier
9. Click notification and get error
10. Error: ORA-20002: 3240: Error '-6502 - ORA-06502: PL/SQL: numeric or
value error: character string buffer too small ' in 'PLSQLCLOB' API
'PON_AUCTION_PKG.GET_DISCUSSION_MESG_BODY' ORA-06512: at
"APPS.WF_NOTIFICATION", line 5512 ORA-06512: at line 6

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot perform any online discussions with the suppliers.

Changes

 

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