Oracle Alert Customization issue
We have Developed Customized Oracle alert for customer/bill to site manual credit hold, this is sending notifications when ever customer or customer bill to site is put on credit hold.
Business wanted this to be restricted to operating unit we have referred operating unit in Alert installations. For Bill to site credit hold it's sending notifiactions correctly.
As customers are not operating unit specific Alert is sending notifications even when customer is updated for credit hold from other operating units
tried to use fnd_profile.Value('ORG_ID) IN Alert sql to restrict to operating unit but it has not helped.