Cannot Perform Writeoffs After Upgrading From 6.0.3 To 7.3 For Some Accounts

(Doc ID 559058.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.0.0.0
This problem can occur on any platform.

Symptoms

When trying to perform account level write-off it seems to fail and the associated cm.pinlog seems to indicate a problem with some data not being there.

This error was found even when a payment was attempted from Payment Tool.

If a new account is created, write off for the account is happening properly. Also notice that the
write-off works for some upgraded accounts.

The only difference that seems to be that some information in bal_grp_t did not have
Balance Group at the account level and effective_t was not populated.

Workaround

The problem does not occur if the bal_grp_obj is made to have the the correct bal_grp_obj from the bal_grp_t for that customer and also updating the effective_t in the table billinfo_t

The upgrade path was:

  1. 6.0.3-6.2SP1
  2. 6.2SP1-6.2SP4
  3. 6.2SP4-7.0
  4. 7.0-7.3





Cause

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