My Oracle Support Banner

Delete Notifications from Inbox That Have Been Read (Doc ID 758248.1)

Last updated on AUGUST 15, 2017

Applies to:

Oracle Agile PLM Framework - Version 9.2.2.1 and later
Oracle Agile Product Collaboration - Version 9.2.2.1 and later
Information in this document applies to any platform.


Purpose

 This document provides SQL scripts for deleting read notifications by all read notifications, a specific user's read notifications, or notifications received in a specific time frame.  In addition to clearing out notifications, these scripts can provide relief from performance symptoms related to excessive undeleted notifications.  These can include, but are not limited to:

1) User cannot open the main page after logging into the Web Client (System hangs or displays blank page or the hour glass keeps running)

2) User cannot open Notification Inbox (System hangs or displays blank page or the hour glass keeps running)

3) Timeout exception when logging into Web Client

Scope

 These SQL scripts are intended to be run by the Agile schema owner and require an understanding of SQL, specifically the SQL DELETE command.

Details

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
Purpose
Scope
Details

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