My Oracle Support Banner

After Upgrade, Issue With Time-stamp Data Insert On START_TS Column In S_NQ_ACCT Table (Doc ID 2702389.1)

Last updated on JANUARY 24, 2022

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


After OBIEE 11g to OBIEE 12c Upgrade, intermittent issue seen on START_TS column of Usage Tracking S_NQ_ACCT table :

Time-stamp HH:MM:SS inserts as 00:00:00 in START_TS column when report executes on particular date and time as seen below.



  1. Login to Analytics with any user
  2. Go to catalog and run some report
  3. It attempts to insert time stamp data with HH:MM in START_TS column on S_NQ_ACCT table under the BIPLATFORM Schema
  4. sometimes time stamp data HH:MM is capturing as 00:00


 Upgrade from 11g to 12c


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.