Event Notification List was not Efficient (Doc ID 2161084.1)

Last updated on APRIL 05, 2023

Applies to:

Symptoms

On : 7.5.0.14.0 version, Event Management

The /config/notify object in Billing and Revenue Management (BRM) is required to configure exact event POID types for every event that an user wished to send to an OPCODE via event notification.

The user has 92 event types and opcode combinations configured for event notification, the /user_activity feature needed to be used to meet partner tracking requirements and it must (by explicit requirement) track every single event generated during a user session (running through a connection pool with context info added per /user_activity feature docs).

This required the user to add 339 more event types and  OPCODEs combinations to /config/notify, i.e. all possible event types (including future event types via deployment automation) to be sure to catch any event generated in the /user_activity object. Using millisecond timing, the user has discovered that this potentially added about 14 milliseconds to the rating of every single event in the system, which could have measurable impacts on daily batches which handle 1 million+ customers some days of the month.

The recommendation is to be able to match event POID type either by (optional) regular expression or to include all sub-classes of a specified event POID type in the notifications (probably an option for backwards compatibility). If nothing else, doing a linear set of string compares against the entire notification list for every event simply cannot be considered acceptable.

Changes

Cause

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