My Oracle Support Banner

Can CN_NOTIFY_LOG and CN_EVENT_LOG Be Truncated? (Doc ID 2658404.1)

Last updated on APRIL 14, 2020

Applies to:

Oracle Incentive Compensation - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

You are updating the dimension in a rate table. The update does not completed and shows a timeout error. You have investigated and found that the problem is in the size of the cn_event_log_all (over 63 thousand records) and cn_notify_log_all (over 74 million records) tables.

You have enabled Incremental Calculation but do not use it. You want to know if you can truncate the cn_event_log_all and cn_notify_log_all tables.
 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.