nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

BI Scheduled Report Job and Daylight Savings Time

Rob Stahly

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

Find more posts tagged with

Answers

OTBI

Report Delivery

Comments

Julian Challenger-Oracle

Moved to OBIEE

Prudence K

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.

Robert Fighiroae-Oracle

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

CJVV

Is there an open ER on this so that we can vote?

Juliet Soriao

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?