Not Able To Send Multiple E-Mails Upon Approval Of Purchase Order (Doc ID 333719.1)

Last updated on MAY 05, 2017

Applies to:

Oracle Purchasing - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Oracle Solaris on SPARC (32-bit)
HP Tru64 UNIX
z*OBSOLETE: Microsoft Windows 2000
HP-UX PA-RISC (64-bit)
IBM AIX on POWER Systems (64-bit)
HP-UX PA-RISC (32-bit)
z*OBSOLETE: IBM AIX 4.3 Based Systems (64-bit)
Oracle Solaris on SPARC (64-bit)
Obsolete Linux Intel (64-bit)
Linux x86
IBM AIX on POWER Systems (32-bit)

Symptoms

Attempting to send a purchase order to multiple e-mails at the time of approving. When two or more e-mails are used no e-mail is being generated

Steps to Reproduce:
1) Enter purchase order and approve it
2) Check e-mail box and type more than one e-mail address separated by comma.
3) The status of the PO will change to approved but it is not sending any e-mail.

wfstat.sql shows the following Errored Activities:

Error Stack
------------------------------------------------------------------------------------------------------------------------------------
EMAIL_PO_PDF_SUPP #MAIL WF_ERROR
[WF_ERROR] ERROR_MESSAGE=3835: Error '-6502 - ORA-06502: PL/SQL: numeric or value error: character string buffer too small' encounte
red during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK=
WF_XML.GenerateMessage(XXXXXXX)
WF_XML.Generate(oracle.apps.wf.notification.send, XXXXXXX)
WF_XML.Generate(oracle.apps.wf.notification.send, XXXXXXX)
Wf_Event.setMessage(oracle.apps.wf.notification.send, XXXXXXX, WF_XML.Generate)
Wf_Event.dispatch_internal()

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