Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 40 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 18 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Dunning Letter File naming within the zip file.
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
Answers
-
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
Hope this help.
Thank you.
0 -
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.
0
