When Migrating Balance Using CMT, /item/misc Is Updated With the Balance Amount From Legacy

(Doc ID 1353350.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 24-Sep-2013.

Goal

A user is using CMT (Conversion Manager Tool) to migrate legacy subscribers and the balances, and then using custom scripts to upload usage and any AR data from the legacy system into the BRM database. These custom scripts will essentially create all the relevant items and events to ensure that the items are included in the pending bill.

While testing the creation of the first bill and invoice after migration and loading of usage/AR items from legacy, it was noticed that the invoice total amount due amount does not match what was expected which should be:
      Previous bill's outstanding balance + Current month's usage - Payments made in this current bill cycle + Any other AR items.

However, the total amount due also includes an /item/misc amount which equates to the balance loaded. So the calculation becomes:
     Legacy system's account balance + Previous bill's outstanding balance + Current month's usage - Payments made in this current bill cycle + Any other AR items.

After extensive investigate, it looks like CMT is updating the pending bill's /item/misc due and item_total when the legacy account balance is being uploaded.

Is there a way to turn this functionality off? Since the user is loading the previous unpaid bills and also all usage + AR items from the legacy system, there is no need for the /item/misc in the pending bill to be updated with the legacy current balance. Assume this is happening to handle the cases where a site may not be migrating usage/bills and AR items from the legacy system.


Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms