Home › Discussions › Questions & Answers › How to handle dynamic date parameters for scheduled jobs

How to handle dynamic date parameters for scheduled jobs

Avatar photoCustomer December 30, 2023 at 4:52 am

I am setting up a daily scheduled report, and the ‘Date From’ parameter needs to automatically shift to be ‘yesterday’s date’ for every run. How is this dynamic date handling configured?

Viewing 6 reply threads
  • Author
    Replies
    • Support December 30, 2023 at 11:56 am  

      For date parameters in scheduled Blitz Reports, you must utilize Oracle’s increment date functionality. This functionality allows the date parameter to adjust dynamically upon each execution of the scheduled concurrent request.

    • Avatar photoCustomer January 1, 2024 at 12:53 am  

      So, I configure the dynamic date directly within the Oracle Concurrent Request scheduling screen, not within Blitz Report setup itself?

    • Support January 2, 2024 at 8:36 am  

      That is correct. You configure the dynamic date logic using the standard Oracle scheduling features available when submitting or copying the concurrent request.

    • Avatar photoCustomer January 3, 2024 at 11:33 pm  

      If I define a parameter as type ‘Date’ in Blitz Report, does it handle timezone conversion differently from ‘DateTime’ when I input a value?

    • Support January 5, 2024 at 5:57 pm  

      Yes, if timezone conversions are enabled, a ‘Date’ type parameter is used as a bind without any conversion (midnight of the date entered). A ‘DateTime’ type parameter, however, will be converted to server time before execution.

    • Avatar photoCustomer January 6, 2024 at 11:50 pm  

      What functions can developers use in SQL text that don’t require selecting from dual?

    • Support January 8, 2024 at 3:20 pm  

      Developers can use many standard Oracle functions like `to_char`, `to_date`, `sysdate`, `add_months`, `months_between`, etc., without needing a `select … from dual` clause. This applies mainly when setting default values.

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

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

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14609

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

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

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11963

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9897

Migration to Java Web Start in Oracle EBS 12.2 instance 9890

Securing sensitive data with Oracle VPD 7793

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

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