My Oracle Support Banner

Backout Pipeline Has UTC_TIME_OFFSET Conversion Problem (Doc ID 1075799.1)

Last updated on MARCH 07, 2019

Applies to:

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


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?


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.