Home › Discussions › Questions & Answers › Adding run details to the report email subject

Adding run details to the report email subject

Avatar photoCustomer December 13, 2023 at 11:31 am

When a report is emailed, the subject line needs to include the Concurrent Request ID for tracking. Is there a placeholder for this?

Viewing 6 reply threads
  • Author
    Replies
    • Support December 15, 2023 at 11:00 am  

      Yes, Blitz Report supports placeholders for automated replacement at run-time within the email subject. You can use the placeholder &REQUEST_ID to include the concurrent request number.

    • Avatar photoCustomer December 16, 2023 at 6:13 am  

      What other useful details can I include dynamically, perhaps the number of rows returned?

    • Support December 18, 2023 at 6:29 am  

      You can include &ROW_COUNT (the number of rows returned), &REPORT_NAME, &DB_NAME, &USER_NAME, and &SITE_NAME. These are replaced when the email is sent.

    • Avatar photoCustomer December 20, 2023 at 4:02 am  

      And how do I change the fixed text template around these placeholders?

    • Support December 21, 2023 at 12:36 pm  

      The default email subject is stored in the Oracle FND message XXEN_REPORT_EMAIL_SUBJECT. You can edit this text via Application Developer > Application > Message.

    • Avatar photoCustomer December 23, 2023 at 7:46 am  

      If I create a custom message, how do I tell Blitz Report to use it?

    • Support December 25, 2023 at 9:39 am  

      You can create new custom messages prefixed with `XXEN_REPORT_EMAIL` and then set the profile option ‘Blitz Report Email Subject Message’ to use your custom message.

  • 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™ 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 8062

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