Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Ratna Elete
    OTBI Custom Report Scheduling -- Date Parameter Increment
    Topic posted July 1, 2019 by Ratna EleteBlue Ribbon: 750+ Points, tagged Fusion Procurement reporting, OTBI 
    70 Views, 1 Comment
    Title:
    OTBI Custom Report Scheduling -- Date Parameter Increment
    Summary:
    How to increment date parameter to run with sysdate for Scheduled OTBI report
    Content:

    OTBI Custom Report has PO Date which is a parameter with in between operator  to choose 2 values

    1.  From-Date = Defaulted to '01-01'2017'

    2.  To-Date = Sysdate.

    Users should have the flexibility to choose the values when run on adhoc but when scheduled it should run from '01-01-2017' to current_date.

    I used 'Procurement-Procure To Pay" subject area.

    I also found this note on metalink "Fusion OTBI: How To Use System Date & Auto Passing Of Dates In OTBI Report (Doc ID 2103487.1)"  but I did find some notes from previous posts on the similar topic where the control is on the parameter itself than on the filter as mentioned in the above KM but looking for suggestions too

    Please advise.

     

    Thanks,

    Ratna

     

     

    Version:
    19B

    Comment

     

    • Ramesh Nayak

      Ratna,

      you have to use nvl as shown below in your query and when you are scheduling the report dont select any parameter value.

      po_date between NVL(:from_date,'2017-01-01') and nvl(:to_date,sysdate)

      Hope this will help you.

      Thanks and Regards,

      Ramesh