Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 12 Oracle Analytics Lounge
- 189 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 65 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BI Scheduled Report Job and Daylight Savings Time
Summary
We had a scheduled that ran an hour early after daylight savings time ended
Content
There is a scheduled report job that runs at 5:30am each wednesday. With daylight savings time ending this past weekend, the job ran at 4:30am instead of 5:30am. The schedule was set up to run at 5:30 Eastern Time, but it doesn't say EST/EDT. I did update the start date to next week in an effort to get it to run back at 530am but wasn't sure if anyone had any advise to ensure that the system runs this at the same time no matter daylight savings time.
This report is based off of an HCM extract in the system, and that process worked as expected with the daylight savings time change, only BI had the issue.
Version
19C
Comments
-
Moved to OBIEE
0 -
Rob - did you ever get an answer about this? I feel like the solution has to do with choosing the 0 GMT (London) vs the 0 UTC, but am not 100% certain.
0 -
Hi Rob,
This is a known issue with the BI Publisher Scheduled Reports.'
The only workaround(s) at this time are to:
- Reschedule the report
- Edit the Schedule then re-save it without making any changes
Scheduled BI Publisher Reports Are One Hour Off After Daylight Savings Change (Doc ID 2648608.1)
Best regards,
Robert
0 -
Is there an open ER on this so that we can vote?
1 -
We have the same issue last March 2023 when CST changed to CDT. It's cumbersome to do the rescheduling every time time changes. Can the change from CST to CDT be automatically reflected to scheduled BIP reports?
0