Performance Issue on Opening a Notification
(Doc ID 1955818.1)
Last updated on JULY 07, 2020
Applies to:Oracle Self-Service Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.
In Self-Service, Worklist, when one opens a notification, the following problem occurs :
it takes 5 seconds to open the notification
Steps to Reproduce
1. Log in using a Self-Service responsibility
2. In the Worklist, open a notification
3. Check that it takes 5 seconds to open the notification
The cause of the problem is that pqh_ss_approval_history is not purged (see ER 5001556)
select count(*) from pqh_ss_approval_history;
-> 2060353 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