Alert Required for Item Shelf Life

[oraora7]

I have set shelf life in Item Master. How to set Alert for shelf life, my client wants Alert 15 days before Expiery. Kindly suggest me.

[admin]

Pl check Oracle Alerts to implement the same. thanks

[prabhakar]

Hi ,
As admin proposed we have Alert module in which we have Periodic and Event based alerts.
Event Alerts will fire whenever a change is occured in the database .This event alerts were defined against a table or view.
Stating that whenever a insert or update is made for the table the alert defined for that table will fire.
If u explain your requirement in detail i can help u out in depth.