PeopleSoft has a record named PS_PT_WF_NOTFY_TBL
which keeps track of the user (CREATEDOPRID) who triggered the
notificaiton, the time (CREATEDTTM) of the notification and To, Cc, Bcc
details, Email Subject, Email Body.
However PS_PT_WF_NOTFY record is used only for notification functionalities and not the standard workflow
Notification functionality is writted in the application package PT_WF_NOTIFICATION:Notification. This App Package has a method InsertNotificationRecord which inserts the notification details in PS_PT_WF_NOTFY table.
This record can be used to track emails sent using Send Notification functionality. The only way I know to track PeopleSoft standard workflows that get triggered through TriggerBusinessEvent function is to check the smtp.log file.
To track emails, first we could check this record with a query as simple as the below:
SELECT * FROM PS_PT_WF_NOTFY_TBL ORDER BY CREATEDTTM DESC;
If we could not get any information in this record chances are that the workflow which got triggered was not making use of the Send Notifcation functionality.
However PS_PT_WF_NOTFY record is used only for notification functionalities and not the standard workflow
Notification functionality is writted in the application package PT_WF_NOTIFICATION:Notification. This App Package has a method InsertNotificationRecord which inserts the notification details in PS_PT_WF_NOTFY table.
This record can be used to track emails sent using Send Notification functionality. The only way I know to track PeopleSoft standard workflows that get triggered through TriggerBusinessEvent function is to check the smtp.log file.
To track emails, first we could check this record with a query as simple as the below:
SELECT * FROM PS_PT_WF_NOTFY_TBL ORDER BY CREATEDTTM DESC;
If we could not get any information in this record chances are that the workflow which got triggered was not making use of the Send Notifcation functionality.
No comments:
Post a Comment