My Oracle Support Banner

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

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




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

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