E-PN: Questions Related to Configuration of the Archive and Purge for Push Notifications (Doc ID 2352504.1)

Last updated on AUGUST 21, 2023

Applies to:

Goal

Questions related to the configurable Archive and Purge for Push Notifications.

1. Running the PeopleTools, Push Notification, Notification Window, Configuration, System Configuration, Archive and Purge, wants a category name specified or allow it to do all of them. Do I let it default to all?

2. The suggestion that Push Notifications can be purged for all PTPN_MSG_STATE='Dismiss' in PSPTPN_MSG_TBL, sounds like the Purge should only delete those rows that are in the DISMISS state. Trace shows that the SQL is;

DELETE FROM PSPTPN_MSG_TBL WHERE PTPN_CATEGORY_NAME=:1 AND LASTUPDDTTM BETWEEN :2 AND :3

It looks like it deletes everything in a date range (possibly limited to a single category) without considering dismissed or not. Is this a problem?
 

Solution

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