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 laterInformation in this document applies to any platform.
Symptoms
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
Additional information:
The cause of the problem is that pqh_ss_approval_history is not purged (see ER 5001556)
sqlplus apps/apps
select count(*) from pqh_ss_approval_history;
-> 2060353 rows
select count(*) from pqh_ss_approval_history;
-> 2060353 rows
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |