Hi
We have a BIP report with daily frequency, and we need to pass the schedule start time to the data model SQL input parameter#p_from_date to fetch the incremental value.
Sorry. I don't know how to pass when to start to a BIP scheduled job.
Using a SOAP request API in a custom program(such as Python etc) to submit a BIP schedule job could be one of alternate option. You can control when to start the job in your custom program as you like though you need to develop it by yourself.
https://docs.oracle.com/middleware/12213/bip/BIPDV/scheduleservice.htm#CACCCCBD 3.35 scheduleReport() Method
Regards, Kentaro
Use {(SYSDATE()$} see:
https://docs.oracle.com/middleware/12212/bip/BIPUG/GUID-BC0A8B60-1BB5-4D85-85BB-B199C1A5C418.htm#BIPUG219
Rgds,
Kevin
If you know the frequency, let's say within last 24 hours, you can use TRUNC(SYSDATE)-1
This automatically picks records from the last 24 hours (yesterday to now). You can adjust the interval as needed (e.g., use SYSADATE-(1/24) for hourly, etc.).
This avoids parameters altogether if your schedule runs consistently (daily, hourly, etc.).
Hi Mayur,
You can write a with clause CTE in your query which will give you the schedule start date and time and then use that in your main query.
Thanks.
