Home › Discussions › Questions & Answers › How to execute an external script after report completion

How to execute an external script after report completion

Avatar photoCustomer January 31, 2022 at 12:56 am

I need to run a shell script to compress the output file and then FTP it to a separate server immediately after the report finishes running. Where do I define this action?

Viewing 6 reply threads
  • Author
    Replies
    • Support January 31, 2022 at 5:51 pm  

      You define this using the Custom Postprocess runtime option. This option allows a custom shell script to run after report completion, typically used for distribution or output transformation.

    • Avatar photoCustomer February 1, 2022 at 8:29 pm  

      Where must this shell script file be located on the application server?

    • Support February 3, 2022 at 1:04 pm  

      The script must be placed under the $CUSTOM_TOP/bin/custom/ directory, for instance, `$XXEN_TOP/bin/custom/generate_and_send_pdf.sh`.

    • Avatar photoCustomer February 4, 2022 at 10:09 am  

      If I create a new script, how do I make it selectable in the Options window LOV?

    • Support February 4, 2022 at 9:23 pm  

      To add a new custom postprocess script name to the runtime options LOV, you must add it to the Oracle lookup XXEN_REPORT_POSTPROCESS_SCRIPT.

    • Avatar photoCustomer February 6, 2022 at 8:32 pm  

      Can I default this custom postprocess script at the report setup level?

    • Support February 7, 2022 at 5:50 am  

      Yes, the Report Options section of the Setup window includes the Custom Postprocess field, which provides the same functionality as the runtime option to default a postprocess on the report level.

  • Author
    Replies
Viewing 6 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™ 123806

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

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14683

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

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

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11999

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9946

Migration to Java Web Start in Oracle EBS 12.2 instance 9938

Securing sensitive data with Oracle VPD 7865

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

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