POAPPRV ORA-06512"DOES_USER_WANT_DOC_EMAILED" When Multiple emaill address are used

(Doc ID 2285942.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Purchasing - Version 12.1 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

PO is Approved and workflow failed sending email notification when using multiple email addresses.

l_role has limit of char 320

If the size of combination of multiple email addresses is over 320, then the error is generated.

ERROR_STACK
DOES_USER_WANT_DOC_EMAILED (Does User want document e-mailed)
#EXCEPTION
-6512
ORA-06512: at line
Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_INIT1.EMAIL_DOC_YES_NO, POAPPRV, xxxx-xxxx, xxxxx, RUN)




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