Question on the Options Field
Hi Andy,
Hope your day is going well. I am working on file extract and transfer within EBS and decided to use Blitz Report instead of the traditional UTL_FILE package. Below is a screenshot of my report:

Below are my questions:
- For the Output format : CSV, how do I enclosed columns with double quotes to avoid issues when this file gets loaded into another system?
- Under Output Filename ( and Additional Output Filename ), is it possible for this to accept an Oracle SQL Function? The reason being is that when user picks a GL_PERIOD_NAME parameter, it uses the value and add it to the file name. The problem arises when the GL_PERIOD_NAME is September since the GL_PERIOD_NAME for SEPT-XX which is one character more than the rest of the period. I would like to rename it the SEP-XX before the file gets created and transferred to the vendor. If it’s not possible, we may need to do it in the Custom Postprocess script.
4 replies
- You must be logged in to reply to this post.
Sign in with LinkedIn or Google to take part.






