Dunning Letter File naming within the zip file.

Question

Currently, using Bursting, I am able to place the “Dunning Letter” output zipped PDF files with naming convention ("Dunning_'Dunning_id'.zip") directly into the SFTP location. However, as per the requirement, the output name for the individual pdf inside the zip file should have naming convention as "combination of the customer account number and the dunning letter generation date". But currently the system is automatically generating the name of the output pdf file as "Doc001.pdf".

Is there any way we can Name the PDF file(inside the zip file) as per the requirement. I also want to know when we do Bursting in ZIP file format, will this ZIP multiple PDF files into one or one ZIP file for one PDF file

User_QAVVI · Answer

Hi @Bhaskar Konar ,

Thank you for the reply.

Both the posts suggest to add a new column as OUTPUT_NAME (We already have this in our Bursting query). Even though we add OUTPUT_NAME as a column, it will just rename the name of the zip file but it will not rename the pdf file.

Is the naming of pdf file(which is inside a zip file) an automatic process or can we control it to rename the pdf file?

Thank you.

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/27852/dunning-letter-file-naming-within-the-zip-file

Hi @User_QAVVI,

Welcome to the Oracle Analytics Community!

Please take a look into the following posts for your first query (renaming the dunning letters).

Can we change the file name of the attachment to dunning emails? — Cloud Customer Connect

Can we change the attachment file name of Dunning letter . Default attachment showing as Output.pdf — Cloud Customer Connect

Hope this help.

Thank you.