When we create custom workflows it is always a best practice to log the emails sent into a custom record which will help us track the emails sent. 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. SELECT * FROM PS_PT_WF_NOTFY_TBL ORDER BY CREATEDTTM DESC To track emails, first we could check this record with a query as simple as the below: The only way I know to track PeopleSoft standard workflows that get triggered through TriggerBusinessEvent function is to check the smtp.log file.
This record can be used to track emails sent using Send Notification functionality. 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. However PS_PT_WF_NOTFY record is used only for notification functionalities and not the standard workflow. Likewise, opinions or comments expressed by visitors are not endorsed or recommended by the author.
#PEOPLESOFT AWE EXAMPLE CODE#
Yes, 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. The PeopleSoft tips and tricks, code samples, examples, solutions, workarounds mentioned in this blog are only the author's views and not that of Oracle or any other products or tools provider. Is there a way to see which email was triggered to whom with what subject? Who was copied(Cc) and blindly copied(Bcc) in that workflow notification? Is there a record or a log file which tracks the PeopleSoft delivered emails sent as a result of user transaction sin PeopleSoft? Does PeopleSoft provide a way to track the workflows/emails sent?
0 kommentar(er)
