Different Timezone In Two Ifw_sync Queues

(Doc ID 2403961.1)

Last updated on JUNE 04, 2018

Applies to:

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

Goal

On Oracle Communications Billing and Revenue Management (BRM), 7.3.1.0.0 version, it is observed that different timezones are being used for different ifw_sync queues.

For example, after creating a new "ifw_sync_dataonly2" queue in Oracle 11G 11.2.0.4, the "ENQ_TIME" of "ifw_sync_dataonly2" stores GMT time but ifw_sync stores a timestamp based on local time (eg. HKT or GMT+8).

As per the below column timezone in AQ$QUEUE_TABLES, ifw_sync and ifw_sync_dataonly2 values are GMT and GMT+8 respectively.

Recently Oracle database have upgraded from 10G to 11G (11.2.0.4).  In Oracle 10G environment, the timezone setup is GMT+8.  After upgrade, the Oracle 11G environment changed timezone to UTC.

How can the queue table columns ENQ_TIME and DEQ_TIME both be in Hong Kong Time (HKT)?

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