How Should the Reprocessing of Records be Performed for Oracle Knowledge Analytics version 8.5.x Only

(Doc ID 2190610.1)

Last updated on AUGUST 29, 2017

Applies to:

Oracle Knowledge - Version 8.5.1 to 8.5.1.5 [Release 8.5]
Information in this document applies to any platform.

Goal

Running reprocess ALWAYs requires that you reprocess all the data from that date forward to the current date, in the order of the data.  You cannot process week 3 and then week 2.  You must process week 1 then 2 then 3 and so on.  The reprocess package in both releases deletes some of the analtyics data so that it can be reprocessed correctly.  This assumes that ALL data will be reprocessed.  If you need to process only one week of old data then please open a SR with Oracle support to get the correct steps to process that week.

In 8.5.1, PKG-ORACLE_REPROCESS deletes data from the AGG_WEEK and AGG_MONTH tables.

When we run PKG-ORACLE_KNOWLEDGE_MAIN, AGG_WEEK and AGG_MONTH data that was cleared after Reprocess package was run is not restored again for the respective week and month.

eg: If we run reprocess on the 4th of a month, AGG_WEEK and AGG_MONTH data for this month and week onward are deleted.  When we run the Main package, calculation for AGG_MONTH is done with data starting from 4th. Similarly with AGG_WEEK. As a result inaccurate records could be displayed for weekly and monthly reports.

In this case the full reprocess package is not run.

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