Backout Pipeline Has UTC_TIME_OFFSET Conversion Problem

(Doc ID 1075799.1)

Last updated on SEPTEMBER 12, 2013

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.

Goal

We have found that conversion between database timestamps to pipeline dates is incorrect. Dates in pipelines are converted as one hour less then they are presented in pin DB. When we use event extraction tool to extract data from database and send this data to rerating, start time of rating is one hour less then it was actually loaded before.

Please explain why pipeline conversion of timestamps to dates is not correct?
Please point out if there is any configuration missing or  the suggested solution of this behavior?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms