Skip to Main Content
Forums

APEX

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!

APEX Email Custom PDF Report

BaonergesMar 11 2020 — edited Mar 11 2020

Hi Everyone,

We are working on an invoicing application which can take a reports and email it as a PDF. Currently we run a crystal report which generates the invoice, then we save as a PDF and email it.

I have been trying to figure out how to create a custom report format which matches my invoice format and can be emailed as a PDF from my APEX application. Currently I am playing around with APEX Office Print (AOP) to see if this will do what I need. Its somewhat expensive though with the volume.

The following link discusses how to integrate with Crystal but it needs a Crystal Server. I am willing to redevelop my report in any format as long as I can customize the formatting and location of data on the page. I don't want the APEX downloadable report which spits out a table.

How to generate a PDF report from APEX using Crystal Reports

Is there a simpler way for me to use built in APEX functionality to generate a custom PDF and then send it with an email?

Any guidance would be appreciated.
This post has been answered by Scott Wesley on Mar 11 2020
Jump to Answer

Comments

LeightonLNelson
Hi,
First I recommend to remove your hostname information from the output of your post.
From the output it seems to indicate that your OMS is down. Could you please verify that the OMS in question is up using emctl status oms.
What command did you use to remove the plug-in? Does emcli list_plugins_on_server show the deployed plug-in?

Thanks,
Leighton
EdSpn
Hi Leighton,

Thanks for the feedback. I just checked status oms and it seems fine:
[oracle@dwbi-durl-oel agent_inst]$ $OMS_HOME/bin/emctl status oms
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
WebTier is Up
Oracle Management Server is Up
Yes, my plugin is still listed. I always use the following commands to undeploy:
emcli delete_target -name="$TARGET_NAME"    -type="$TARGET_TYPE_NAME"
emcli undeploy_plugin_from_agent  -plugin="$PLUGINID" -agent_names="$AGENT_NAME"
emcli undeploy_plugin_from_server -plugin="$PLUGINID" -sys_password="$SYSPWD"
I think the issue may be caused by another plugin. Will dig further.

Thanks,
Ed

PS That hostname slipped through into the post. Just removed it :)
EdSpn
To complete the thread:

I have found the offending plugin, and undeployed it (using the OEM UI in browser).
After this, the issue was resolved, and I could successfully undeploy my own plugin.

Regards,
Ed
Which plugin did you undeployed ?
EdSpn
It was not an Oracle provided plugin, but one of our own.
1 - 5

Post Details

Added on Mar 11 2020
#apex, #apex-discussions, #email, #pdf
4 comments
960 views