Dynamic output Filename

Saurabhjain8

Summary

Dynamic output Filename

Content

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

https://docs.oracle.com/middleware/bi12214/bip/BIPUG/GUID-22F94743-8AB7-43E8-AEE8-3D022AB306B2.htm#BIPUG221

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

Hi,

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

Similarly the file name also

Thanks,
phanidra

Saurabhjain8

Hi Phanidra,

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

Sanjay Chaurasia-28291

Is this resolved?

 

Thanks

Sanjay