My Oracle Support Banner

Duplicate Check While Using Load_notification_event Utility To Prevent Loading Of Same Xml Twice in BRM 7.4 (Doc ID 1498553.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Goal

On Oracle Communications Billing and Revenue Management(BRM), 7.4.0.0.0 Version,

Below are the steps followed for the issue reproduction

1.  Created a Non Currency Resource(NCR).
2.  Created a new Discount  -  to accumulate  the Total charge for the CDR in our NCR
3.  Created a plan  with Credit Limit:
         Account Balance Group. (for this NCR ) with this Threshold
        (30%,50%,60%,80%,100%) and the limit = 80.
4.  In BRM set these business parameters:  balance_monitoring = 1 and CreditThresholdChecking =1
5.  Created an account with this plan
6.  In the registry file, configured this modules:
 

 
7. Pass the usage so as to breach the notification and notification xml got generated in the directory

<IFW_HOME_DIR>/data/out/notifybalancebreach

Question 1.

Using load_notification_event utility while loading the notiication event xml that got  generated when account  balance  crosses the threshold,  there is no such check which will prevent the same xml file to be loaded twice in the BRM System. In other words there is no duplicate check. Something which is present in IREL application.
 
The expectation is that when you load the same xml file using load_notification_event utility, it should fail the second time when the user tries to load it.

As it happens in pin_rel when the rated CDR file is loaded twice, it gives error while loading  the same file, twice.

Question 2.

After successfully passing the EDR, Batch controller has loaded a file successfully & moved the file to done directory.

If by some mistake, someone moved the xml file back to processing directory. In that case, would batch controller discard the file from being loaded twice? Or it will be loaded as duplicate?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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