Performance issue on opening a notification

(Doc ID 1955818.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Self-Service Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In 12.1.3, 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. Login 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




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms