Collapse
Submit a Service Request
Contact Information for Technical Support
My Service Notifications
Missing KF_ANSWER_STATS before a specific date
Answer ID 5830 |
Last Review Date 08/16/2024
Why is there no KF_ANSWER_STATS data before a specific date?
Environment:
Oracle B2C Service
Resolution:
Note that portions of these tables are purged according to the KF_ACTIONABLE_DATA_PURGE_DAYS configuration setting. The default value for this setting is 45 days. This value can be modified.
Cause:
The following tables were added in an earlier release (November 2011):
KF_ACTION_STATS
KF_ANSWER_STATS
KF_ERROR_STATS
KF_ESCALATION_SESSIONS
KF_ESCALATION_STATS
KF_REFERRER_STATS
KF_SA_LOG
KF_SEARCH_STATS
KF_SEARCHES
KF_SMARTASSISTANT_STATS
KF_TOP_ITEM_STATS
There is information on end user visits and answer views in the STATS and ANS_STATS tables. Refer to the standard reports that reference these tables and the data dictionary for more information.