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

Question

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).

VCKUMAR · Answer

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

Yogen · Answer

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

Yogen · Answer

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.