Not Able To Send Multiple E-Mails Upon Approval Of Purchase Order
(Doc ID 333719.1)
Last updated on SEPTEMBER 05, 2022
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()
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |