Workflow Error When Additional Contact Email Field for Supplier is Entered in RFQ (Doc ID 2138321.1)

Last updated on JULY 27, 2017

Applies to:

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

Symptoms


The PONPBLSH workflow errors out when supplier is assigned with additional email in the RFQ. The error message is:

ERROR
-----------------------
ORA-01403: no data found ORA-06512: at "APPS.WF_NOTIFICATION", line 5774 ORA-06512: at line 6

ERROR from Wfstatus
----------------------

Noitify additional contact of auction start #MAIL WF_ERROR
[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 strin
g buffer too small
' in 'PLSQLCLOB' API 'pon_auction_pkg.GEN_INVITE_ADD_CONT_RESP_BODY'

Wf_Notification.GetAttrClob(162013, PON_INV_RESP_ADD_CONT_BODY, text/html)
Wf_Notification.oldGetAttrClob(162013, PON_INV_RESP_ADD_CONT_BODY, text/html)
WF_NOTIFICATION.GetFullBody(nid => 162013, disptype =' encountered during execution of Generate function 'WF_XML.Generate' for event
'oracle.apps.wf.notification.send'. ERROR_STACK=
WF_MAIL.GetLOBMessage4(162013, 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.GEN_INVITE_ADD_CONT_RESP_BODY'

Wf_Notification.GetAttrClob(162013, PON_INV_RESP_ADD_CONT_BODY, text/html)
Wf_Notification.oldGetAttrClob(162013, PON_INV_RESP_ADD_CONT_BODY, text/html)
WF_NOTIFICATION.GetFullBody(nid => 162013, disptype => text/html)
WF_MAIL.GetLOBMessage4(nid => 162013, r_ntf_pref => MAILHTML), Step -> Getting text/html body)
WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 162013)
WF_XML.Generate(oracle.apps.wf.notification.send, 162013)
WF_XML.Generate(oracle.apps.wf.notification.send, 162013)
Wf_Event.setMessage(oracle.apps.wf.notification.send, 162013, WF_XML.Generate)
Wf_Event.dispatch_internal()


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

1. Create new RFQ

2. While adding suppliers, enter e-mail address in Additional Contact Email column 

3. Publish the RFQ

4. When the RFQ is published a new WF is launched for WF item type PONPBLSH. Review workflow status, it shows the following error:

Main auction publishing process/Noitify additional contact of auction start

ERROR #MAIL WF_PON_ADD_USER

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:
character string buffer too small

 

When clicked on the Open link under Notification

ORA-01403: NO DATA FOUND
When clicked on Error link under Status
Worflow Errors: PONPBLSH,
ERROR_MESSAGE=3835: Error '-20002 - ORA-20002:2018:Unable to generate the notification ...

 

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