My Oracle Support Banner

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

Last updated on OCTOBER 02, 2023

Applies to:

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


 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


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


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.