Hi-Is there a way to send a file with a filename of current month's name in SFTP Server in BI Pub?

Cristelle Rose Sampang

I need to send a file with filename of TEST.2023JUL31. In BI Publisher, %y and %d is working for 2023(current year) and 31 (current day), however is there any syntax to use in defaulting to current month's name aside from using %m - which is getting a numeric value for Month?

Mallikarjuna Kuppauru-Oracle

Hi @Cristelle Rose Sampang

No we don't have any option to generate the name only we can generate the number.

Refer - https://docs.oracle.com/middleware/12212/bip/BIPUG/GUID-BC0A8B60-1BB5-4D85-85BB-B199C1A5C418.htm#BIPUG219

Regards,

Arjun