Issue with Oracle Alerts
We use Oracle Alerts to send remainder emails regarding pending notifications. And we have configured these alerts to be run on specific dates of a month like 12th and 15th. For fixing any issues, we do the changes on our dev/test instance and extract them to an LDT and get them tested on QA instance and then move it to Production instance.
We have made a recent change to couple of the alerts which were supposed to be run on every 12th and 15th day of a calendar month, but after the changes they are run daily.
Following are the changes: