My Oracle Support Banner

Cannot Perform Writeoffs After Upgrading From 6.0.3 To 7.3 For Some Accounts (Doc ID 559058.1)

Last updated on MAY 26, 2019

Applies to:

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


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.

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




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.