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 MAY 24, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Other

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.

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