Unifier (MOSC)

MOSC Banner

Reconcile Timezone Differences Between Custom Print, Unifier, and Data Model?

in Unifier (MOSC) 2 commentsQuestion

With BI Publisher and Unifier 25.6 b-05232025-22, I'm trying to understand if we're seeing a bug or an implementation error with a custom print.

We create a record for our BP with datetime fields with users configured to be local to HST. This data displays fine in Unifier.
When we query this record with our data model in BI Publisher we're seeing the value of the time shifted to Pacific Time (server time, verified by support), but the UTC offset is set to 0 rather than the correct Pacific Offset (-8), for example the user inputs 8:30am into Unifier and we get back "2025-07-15T11:30:00.000+00:00" from our data model query.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center