You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • OTBI Custom Report Scheduling -- Date Parameter Increment

    edited Jul 1, 2019 8:32PM in Reporting and Analytics for ERP 1 comment

    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

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!