How to Recover from ApprovalEvent Being Disabled and High Number of Rows in ApprovalQueue Table?
(Doc ID 2380709.1)
Last updated on MAY 27, 2021
Applies to:Oracle WebCenter Sites - Version 22.214.171.124.1 and later
Information in this document applies to any platform.
Is there a way to manually purge the ApprovalQueue table?
The ApprovalQueue table contains a large number of rows (e.g. millions) due to the ApprovalQueue event being disabled for some time.
Now that the ApprovalQueue event is enabled, it is taking a long time to purge these records.
Is there a way to manually purge these rows?
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