My Oracle Support Banner

UNIQ_DOC_VIEW_CNT Does Not Contain The Count Of Unique Documents Viewed (Doc ID 2202401.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.


The UNIQ_DOC_VIEW_CNT in table FACT_USR does not contain the count of unique documents viewed by the user for that date.

The count of unique documents viewed is determined per batch run, so when the events of one day are processed by multiple batches, the UNIQ_DOC_VIEW_CNT is not reliable.

The measure UNIQ_DOC_VIEW_CNT given under FACT_USR table does not work when aggregated. Such measures should not have been calculated in the ODI layer but calculated on the reporting side.

The information of who has viewed an article on which day along with the version and other dimensional attributes available in FACT_CONTENT table




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.