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.
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.
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