Dynamic output Filename

Saurabhjain8 · May 21, 2018 7:00AM

Summary

Hi,

I am using BIP 12c and need to dynamically set the output filenames for reports delivered over Email as excel and pdf.

I need to name the files as myfile_ddmmyyyy and put mail subject as report_for_ddmmyyyy

As per Oracle docs

I can use below

myfile_%d%m%y , but the same isnt working. I am getting the output as myfile_%d%m%y only instead of myfile_21052018.

Could anyone please help?

User_4M27J · May 22, 2018 7:00AM

Hi,

You can use subject as 'report_for'||to_char(sysdate,'DDMMYYYY')

Similarly the file name also

Thanks,
phanidra

Saurabhjain8 · May 23, 2018 7:00AM

Hi Phanidra,

This doesnt work either. It returns the same expression in subject and filename.

Sanjay Chaurasia-28291 · Aug 21, 2018 12:12AM

Is this resolved?

Thanks

Sanjay