ORCH: How To Create a Notification That Filters Data Based On the Subscription Input Override (Doc ID 2851059.1)

Last updated on FEBRUARY 25, 2022

Applies to:

Goal

The goal is to filter the result of a data request where a subscriber only receives the notification when the data matches the subscriber's input override in "My Subscription".  If the Input Override doesn't match, then the end user doesn't get notified. 

The attached sample fetches F0101 which is Address book number less than 2000 and search type = E.   In this case, it returns 2 records.  Make sure these two records have some kind of Long Address Number (e.g. 000000 and 123456). 

The flow looks like below picture and the notification works.  However, if the user doesn't change any inputs for the notification, they receive two notifications for this example. 

The end user wants to receive the notification only when the data contains 12345 for the Long Address.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.