Etext output is delivered as .txt (Incorrect) on email but as .csv (correct) on FTP BIP 11g

Yogen

Summary

Etext output is delivered as .txt (Incorrect) on email but as .csv (correct) on FTP BIP 11g

Content

Hi,

We are using BI publihser 11g and need to deliver .csv output files on email. We used etext template however BI publisher 11g seems to have a bug.

Issue is that files on emails are being delivered with .txt extension instead of .csv.

Same files if delivered on ftp channel it is being delivered perfectly with .csv extension.

Can anyone please confirm what needs to be done so that email also delivers files with .csv extension?

Below is another thread where the same query was raised but no answer was given (not even by Oracle).

YGUTTIKONDA

Please verify the following discussion which may help you ..

https://support.oracle.com/epmos/faces/CommunityDisplay?resultUrl=https%3A%2F%2Fcommunity.oracle.com%2Fthread%2F3569460&…

snippet from the same link

Hope this helps ..

YG

Yogen

Thanks for response. It has not resolved the issue though as I mentioned we could correct file in .csv format if we do an ftp of the file however same file if we deliver on email (using BIP bursting) it gets unwanted extension '.txt' in the file.

Yogen

Another information to share here is that if I follow the steps you just showed, I get the extension .csv even on email attachment but the output ignores report layout and just gives the data dump from xml publisher data model, which is of no use for us.

Yogen

Finally Oracle has excepted this as bug. ER is raised we are waiting for BIP product to be enhanced.

VCKUMAR

Do we know if this bug has been fixed. We still see the issue