Oracle Apps Notification Mechanism

Database Change Notification is a feature using which Client applications can receive notifications when the result set of a registered query changes. The notifications can be published in response to DML or DDL changes on the objects that are associated with the queries. For example, if the client application wants to be notified whenever employee table is modified, the application can receive a database change notification when a new row is added to the table. The queries on this table are registered and the application would be notified on changes to this table. Database Change Notification is relevant to the mid-tier applications that rely on cached data.