Purging Notifications Framework Records
The Notifications Framework can generate a huge amount of transactional data. For performance improvement and data managing requirements, the process of archive and purge becomes very important.
PeopleSoft Data Archive Manager is used for archiving or purging NFK transaction data.
The end-user enters the date until when the archiving is required. After the date is entered, the process retrieves all data from the NFK transaction records to the corresponding NFK history records which have been created as part of this feature.
PS Query is the selection tool used for filtering the data to be archived/purged. The NFK records have been added under SCC_NTFREQ_HDR in the Query tree. Simultaneously we created history records for each NFK transaction record, where the archived data will be available after the archive process is run. Archive object and Archive Templates are also delivered as part of this feature.
Query tree – NFK Archive: A child group has been added as shown below:
Image: NFK Archive Query Tree
This example illustrates the NFK Archive Query Tree.
The Archive Object definition delivered. Access the Manage Archive Objects page ().
Image: Manage Archive Object page for NFK Objects
This example illustrates the Manage Archive Object page for NFK Objects.
The Archive Template delivered. Access the Manage Archive Templates page ().
Image: Manage Archive Templates page
This example illustrates the Manage Archive Templates page for NFK Objects.
Access the Archive Data To History page ().
To run the Archive/Purge process, run the SCC_NFK archive template with the following options as shown below:
Image: Archive Data To History page for NFK Objects
This example illustrates the Archive Data To History page for NFK Objects.
Use the Define Binds link to indicate the date until which the Archive is required.