PPM Support Tip: How to find the notifications that still not sent?
In order to verify the notifications records that are still pending, please run the following query:
select from knta_notif_txn_parents
where notification_sent_flag = 'N'
and creation_date < (DATE);
Re: PPM Support Tip: How to find the notifications that still not sent?
Thanks for this, it is helpful if you don't want to log in and run the report, I did change it a bit since even though it's a given the * was missing after SELECT 🙂
WHERE notification_sent_flag = 'N'
AND creation_date < SYSDATE;