The Attachment of the Report Output is not Delivered When Running the Report by Using API fnd_request.add_delivery_option (Doc ID 2999865.1)

Last updated on JANUARY 30, 2024

Applies to:

Symptoms

The issue can be reproduced at will with the following steps:

1. Written the below code to send the report output as an attachment via Email Server using the API fnd_request.add_delivery_option

 V_BOL_DELIVERY := fnd_request.add_delivery_option (TYPE => 'E'                                            -- Email
,p_argument1 => 'XXSWBR QM Certificate Of Conformance - NF:'||rec_coc_invoice.trx_number  -- Email Subject
,p_argument2 => NVL(V_EMAIL_FROM,'notfound@sherwin.com.br')                                             -- From Email Address
,p_argument3 => NVL(V_EMAIL_TO,'notfound@sherwin.com.br')                                                  -- To Email Address
);

2. Submitting and Running the Report.

3. Email delivered to recipients doesn't have the attachment and the body of the email has the junk characters.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.