EDR extension to support Bucket IDs (Doc ID 2927330.1)

Last updated on FEBRUARY 15, 2023

Applies to:

Goal

Customer want to know exactly which units were consumed. They have different offers which add funds to the same balance types. For every event they want to know from which offer the event was paid.

For example: two balance types (ids 40 and 41) in balance type 41 we have two buckets (ids 100 and 101).
Bucket 100 holds 15 units in funds and bucket 101 holds 35 units in funds.
In balance type 40 we only have one bucket (id 200) with 176 units.

If we have an event which costs 60 units the Event Data Record (EDR) will look like this:

SEQUENCE_NUMBER=8303|CDR_TYPE=1|RECORD_DATE=20220409092125|MSISDN=<msisdn>||BALANCE_TYPES=41,40|BALANCES=50,176|COSTS=50,10

After the EDR extension the EDR for the same event with the same starting conditions would look like:

SEQUENCE_NUMBER=8303|CDR_TYPE=1|RECORD_DATE=20220409092125|MSISDN=<msisdn>||BALANCE_TYPES=41:100,41:101,40:200|BALANCES=100:15,101:35,200:176|COSTS=100:15,101:35,200:10

How can this be achieved?
 

Solution

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