Home › Discussions › Questions & Answers › Question on the Options Field

Question on the Options Field

Avatar photoCustomer January 4, 2025 at 1:41 pm

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:

  1. For the Output format : CSV, how do I enclosed columns with double quotes to avoid issues when this file gets loaded into another system?
  2. 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.
Viewing 3 reply threads
  • Author
    Replies
    • Support January 4, 2025 at 9:40 pm  

      Hi,

      Regarding the double quotes: Excel standard only adds these if they are required due to special characters in the data, such as comma or upper quotes. This is also the approach that Blitz Report uses. Here is an example:

      And regarding the second filename question:
      You (currently) cannot use a dynamic SQL function for the output filename, but you could use a workaround using a dependent hidden parameter having a dynamic default value like this:

      Would this work for your requirement?

      Regards,
      Andy

    • Avatar photoCustomer January 6, 2025 at 10:32 pm  

      Hi Andy,

      Thanks for the tip.  I was able to rename the output file from SEPT-20 to SEP-20!  I really appreciate your quick response!

    • Support January 7, 2025 at 7:10 pm  

      Hi,

      Thanks for the confirmation.
      That’s good to hear that it works as expected :-)

      Regards,
      Andy

    • Avatar photoCustomer January 8, 2025 at 5:53 pm  

      Hi Andy,

      That was easy.  Thanks again!

  • Author
    Replies
Viewing 3 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123992

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 20560

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14853

How to check if a patch is applied in Oracle EBS 12.2 14616

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14264

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 12113

Migration to Java Web Start in Oracle EBS 12.2 instance 10115

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 10071

Securing sensitive data with Oracle VPD 8061

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6638

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2027
2036
2025
2024
2023
2022
2021
2020
2019
2018