Oracle Alert for Receiving Transactions
Just want to ask assistance on how create Alert. I want to create Alert Notification if Receipt transaction is already inserted in RCV_SHIPMENT_LINES. I have successfully configure alert but in every record insert to a table a notification is send also. I want that on a per document. e.g. one Receipt_Num would have 10 lines (RCV_SHIPMENT_LINES - 10 lines ) and one record in RCV_SHIPMENT_HEADER. In this case, since it is referring to one Receipt Num - only 1 notification will be sent having the 10 lines in the details.
Is anyone able to create alert like this? Please help me so that my problem will be resolved.