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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

435868
Hi,

I'm wondering too ...

Will there be an integration in future releases of OWB and BPEL, just like OWB and OWF ?

Or will we have to re-develop all our process flows? We have a number of quite elaborate process-flows and re-building them in BPEL would mean a lot of work for us.

Grtz.
292515
Hi,

look at this part of the desupport page from oracle:

"Existing Oracle Workflow customers continue to receive error correction support up until the same date that error correction support ends for product bundle purchased which include Oracle Workflow. For example, Oracle Database 10gR2 customers using Oracle Workflow will receive error correction support for Oracle Workflow until error correction supports ends for Oracle Database 10gR2. "

So the error correction support goes on.

Regards
Detlef
189894
Hi Detlef

Not really helpful, though, is it. There's another thread on BPEL. Again, same problems.
No clear way forward.

Cheers,
Donna
189894
Hi,

I checked over on the Workflow thread, and this is what is said:

"Workflow desupport starts this September for standalone Workflow. The Oracle plan is for everyone to migrate to BPEL - however, I haven't seen anything from Oracle that details how this is achievable without a complete rebuild."

This is scary stuff. Sure, OWF client is integrated into OWB, OWF server is not. And here's what Oracle say:
"Oracle Workflow Client and Oracle Workflow Server will not be included in Oracle Database Editions 11g and above.
Oracle Workflow will only be included in Oracle E-Business Suite releases."

Which means OWB is stuffed post 10gR2? Or even just for planning post-September?

Unhappy,
Donna

p.s. I understand that while OWF is bundled (i.e.e 'free'), BPEL is a bolt-on at about 12,000 UKP per CPU.

That was from Matthew Searle. He has a website at http://www.workflowfaq.com/ and it has a forum where this topic is one of the discussions. Worth reading.

null
19319
Hello!

Interesting. The same document also contains this, but it is not quoted yet:

"A restricted use version of Oracle Workflow components will be embedded in Oracle Warehouse Builder for customers licensed to use Oracle Warehouse Builder for Oracle Database 11g R1"

So it seems existing solutions will work under 11g but new developments should go into a different direction.

Regards,
Robert
189894
Hi Robert,
. . .The same document . . .
What document are you referring to please? maybe drop in the URL?

Cheers,
Donna
19319
Sorry!

It is on Metalink. The note id is 391546.1
(Oracle Workflow Cartridge 2.6.X desupport information.)

Cheers,
Robert

Ps. I think I was wrong when I thought the others were quoting from this document.
292515
Hi,

it's Dok 391546.1 published in Metalink.

Regards
Detlef
Joe Brig
The page
http://www.oracle.com/technology/products/ias/workflow/workflow_sod.html
no longer mentions desupport.

Was there a change?

Message was edited by:
Joe Brig
29997
Joe,
the first line on that page is:
"Oracle has announced product obsolescence for Oracle Workflow."

B.
Joe Brig
Now it is. There must have been an old page up this morning.
551146
Did the Workflow de-support come with Oracle Data Integrator installation instructions? At what point does one simply bide their time and wait for Oracle to roll out a lighter version of Siebel that doesn't cost 225K/CPU? It's almost as if Oracle only wants "Enterprise Edition" customers as the BI "Standard Edition" is either being de-supported piece by piece or in the case of Discoverer no further enhancements or improvements are planned.
37820
Hi,

I had an opportunity to discuss with Oracle in this issue.

The Workflow server component will still be supported by OWB in Oracle 11g (bundled) as long a s it manages OWB process flows.

No desupport date has been given as of yet for Workflow managing OWB process flows. The technology that will replace Workflow in OWB has not been decided as of yet.

I hope OWB community will be happy to hear this.

If you hear differently, do not hesitate share your thoughts in this thread.

Thanks in advance.

RI
1 - 13

Post Details

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