OTN Discussion Forums : HTML Format via Email ...

This question is not answered. Helpful answers available: 5. Correct answers available: 1.

Reply to this Thread

Search Forum

Back to Thread List

Replies: 10 - Pages: 1 - Last Post: Nov 2, 2009 2:12 AM Last Post By: gareth.roberts

user628991

Posts: 21
Registered: 04/03/08

HTML Format via Email
Posted: Sep 22, 2009 7:03 AM

When sending output via email in HTML format (from rtf template), all the formating is lost, layout just expands horizontally.

Output is correct when displayed in pdf format.

Also occurs when previewing the output.

Further information:

This is purely a custom rtf template created for remittance report. In the rtf template we have used the filler, we have kept many conditions like if the data spills over to next page based on number of lines,and if the number of data lines is less then also it should align and fit to the table /page etc.

If we remove the filler the output will shrink to half page in HTML page and WE DO NOT want this kind of report output. We need the report output in HTML which should fir to paper size(A4 size) even we have less number of data rows.

Any assistance would be appreciated.

Thanks
Sarah

Tim Dexter

Posts: 2,357
Registered: 01/10/01

Re: HTML Format via Email
Posted: Sep 22, 2009 9:10 AM

in response to: user628991

Hi Sarah

Not sure why your output is expanding. But you can not expect HTML to conform to an A4 format - HTML has no concept of a page, either height or width wise. If you want an A4 sized attachment then you ought to use PDF.

How is the template laid out in terms of width. Are there a fixed number of columns to be shown? What formatting are you using?
What version and flavor are you using?
Tim

gareth.roberts

Posts: 1,480
Registered: 08/16/07

Re: HTML Format via Email
Posted: Sep 25, 2009 2:14 AM

in response to: user628991

Hi Sarah,

Does the HTML render properly when run from BI Publisher Desktop? If it does what email client are you using?

Regards,
Gareth

user628991

Posts: 21
Registered: 04/03/08

Re: HTML Format via Email
Posted: Sep 29, 2009 7:27 AM

in response to: gareth.roberts

Thanks for your response.

The customer has updated with the following:

The problem here is the standard program "IBY_FD_SRA_FORMAT module: Send Separate Remittance Advices" sets the output type to HTML if the remittance advice delivery method is "MAIL". Below is the extract from the log file of the program "IBY_FD_SRA_FORMAT module: Send Separate Remittance Advices"
.
******** EXTRACT BEGIN ********
Since the delivery method is EMAIL, the XML Publisher output type is set to be html.
********* EXTRACT END *********
.
This causes the following issue: -
.
The concurrent program ends without generating a pdf output and hence cannot be emailed out as a pdf document.
.
Action required from you: -
.
[1] Ensure that the standard program does not default the output type to HTML for email. This should be PDF instead.
[2] Ensure that IBY XDO Delivery, sends the PDF output as an attachment.

rohitlohan

Posts: 5
Registered: 09/23/09

Re: HTML Format via Email
Posted: Sep 30, 2009 2:45 PM

in response to: user628991

I am having same problem as Sarah.

HTML renders fine when accessing report from BI publisher URL in IE and even PDF renders fine.

When sent in email, all formatting is lost.

Please share anything with me if you have faced same problem.

-Rohit

user628991

Posts: 21
Registered: 04/03/08

Re: HTML Format via Email
Posted: Oct 1, 2009 12:47 AM

in response to: user628991

With regard to this issue, I can appreciate that html does not take on the formatting options produced within the rtf template, although it seems that removing the filler from the rtf template does enable some formatting to be retained in the html output, but still not to the customers requirements.

The problem lies with the standard program IBY_FD_SRA_FORMAT module: Send Separate Remittance sets
the output type to HTML if the remittance advice delivery method is "MAIL".

The issue is therefore being pursued by the product group, to ascertain whether it will be
possible for the program IBY_FD_SRA_FORMAT to be modified so that it does not default the delivery
method automatically to html, so that the customer can then specify the required format.

Thanks
Sarah

PtotheC

Posts: 131
Registered: 05/22/08

Re: HTML Format via Email
Posted: Oct 1, 2009 11:45 AM

in response to: user628991

When you burst to HTML, is it an attachment, or does the report actually appear in the body of the email?

thanks

gareth.roberts

Posts: 1,480
Registered: 08/16/07

Re: HTML Format via Email
Posted: Oct 1, 2009 12:32 PM

in response to: PtotheC

There is no bursting here, the Send Separate Remittance Advices program has implemented its own delivery implementation.

Regards,
Gareth

gareth.roberts

Posts: 1,480
Registered: 08/16/07

Re: HTML Format via Email
Posted: Oct 1, 2009 12:33 PM

in response to: user628991

Hi Sarah,

There is a known issue with certain email clients not honoring the inline CSS stylesheet in the HTML output from BI Publisher - I specifically had this issue with Send Separate Remittance Advices.

What email client are you using?

Regards,
Gareth

user628991

Posts: 21
Registered: 04/03/08

Re: HTML Format via Email
Posted: Oct 15, 2009 6:25 AM

in response to: gareth.roberts

Hi Gareth

Thanks for you help with this

Sorry not responded back but I contacted the product group, as customer requires the following:

We will need the standard IBY_FD_SRA_FORMAT module: Send Separate Remittance to NOT set the output type to HTML because this will affect the Logos and also the formatting.

If the delivery method is email, the output type should be PDF and the document should be sent out as an attachment.

With regard to the email client, this will vary depending on the client of the customer receiving the email.

If you have any suggestions, then I would welcome them very much.

Thanks
Sarah

Edited by: user628991 on 15-Oct-2009 06:26

gareth.roberts

Posts: 1,480
Registered: 08/16/07

Re: HTML Format via Email
Posted: Nov 2, 2009 2:12 AM

in response to: user628991

Hi Sarah,

Just put together a blog post that addresses some of the issues in this thread:
http://garethroberts.blogspot.com/2009/11/html-formatting-issues-in-ebs-r12-xml.html

Regards,
Gareth

Pages: 1

Back to Thread List

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)