My Oracle Support Banner

Updated OverDue Amount Not Interfaced From BRM To Siebel (Doc ID 2081357.1)

Last updated on MARCH 28, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.5.0]
Information in this document applies to any platform.


On Oracle Communications Billing and Revenue Management(BRM), version, Collections Manager, the updated OverDue amount is not getting interfaced from BRM to Siebel.

The following Applications are used here: BRM 7.5 PS9, Siebel and AIA 11.3 Communications PIP.

Here the issue occurs in collections data sync in the following scenario:

1) Subscriber purchases using their Credit Card (Ex: $100).
2) BRM tries to collect payments and due to insufficient funds (could be other reasons too), the payment fails and the Account enters collections.
3) Collections Process is executed in BRM and New Collection Actions are generated (COLL_ACTION_IF_VIEW.EventDescr = "Action Created"). ODI and Siebel EIM Jobs are executed and the Credit Alerts are created in Siebel with OverDue Amount as $100.
4) Siebel sends a first notification reminder to the customer that the OverDue amount is $100 (as per the actions configured). So far everything is good.
5) Now there has been an update to the OverDue Amount in BRM (due to adjustments/payments/Billing on BDOM) (say $150).
6) Collections is executed in BRM. However no new records are inserted/updated in the COLL_ACTION_IF_VIEW for the ODI Job to interface the updates to Siebel.
7) As part of second notification reminder scheduled, Siebel sends the email with OverDue amount as $100 instead of $150.

The expectation is that - in COLL_ACTION_IF_VIEW one should be able to see new records with EventDescr = "Action Updated" so that the Credit Alert lines in Siebel get updated with new overdue amount.

Note: From BRM perspective, all the collections tables are properly updated with correct information. As such, there is no issue/gap in update of overdue amount.  And please reference <note 2083404.1> on AIA side related information.


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

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