Skip to Main Content
Forums

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to call run_report_object and send an email with a pdf report as an attachament

myluismSep 12 2022

Hi all.
I'm using Forms 12.2.1.4 on Linux and would like to run a report from forms via RUN_REPORT_OBJECT. This report will be DESTYPE=MAIL. and DESFORMAT=PDF.
Assuming the mailserver is correctly configured and every time you run a report it will be a one on one output: I mean every time you run the report you will print 1 invoice: for example you run the report the first fime and you pass parameter invoice = 10, it will print that invoice only. I only need the report output as an attachment to the mail.
My question is: will i need report distribution xml file?
This post has been answered by myluism on Sep 14 2022
Jump to Answer

Comments

Nik

Hi.

What  Solaris version you use ? ( 11 ; 11.3 11.4 ? )

Show result of command:   pkg info entire

What version STB you install and what is source ?

Standart path for explorer is :   /opt/SUNWexplo/bin/explorer

Check also this docs:

How to Install/Upgrade Explorer in Solaris 11.3 and 11.4 (Doc ID 2122392.1)

Oracle Services Tools Bundle (STB) - RDA/Explorer, SNEEP, ACT (Doc ID 1153444.1)

Regards,

Nik

Chris W Beal-Oracle

As Nik suggests, knowing which version of Solaris 11 you are using and where you're installing explorer from is key. From 11.3 it's installed by default with most default group packages. /usr/sbin/explorer is a link to /usr/lib/explorer/bin/explorer so either should work

Chris

1 - 2

Post Details

Added on Sep 12 2022
#forms, #moved-from-devops
4 comments
93 views
1 mention