E-PN: How to Remove Orphaned Rows from PSPTPN_MSG_TBL? (Doc ID 2888074.1)

Last updated on OCTOBER 01, 2024

Applies to:

Goal

Site has changed their Unified Navigation configuration to use the FSCM application as the portal, and decommission the Interaction Hub application. The FSCM database contains hundreds of thousands of rows in the PSPTPN_MSG_TBL, and in which the PTPN_ONCLICK_LINK column contains the URL to the old Interaction Hub application.
The distinct PTPN_MSG_STATE values for these rows are: Dismiss, Dismissed, New, Read, Unread. When running the purge and archive application engines from the Notification Administration page, the processes do not appear to be archiving or purging rows that point to the old Interaction Hub application.

How to delete the orphan rows from PSPTPN_MSG_TBL manually using a SQL tool?

Solution

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