Incorrect Valid_From Of Non-Currency Resources After Upgrade (Doc ID 946022.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

-- Problem Statement:
After upgrading from 6.2SP1 to 7.3.1, the valid_from value for non-currency resources displays as Dec 31 1969. This looks incorrect . Could you tell us whether this date should be the billing cycle start date, the account creation date, or the purchased product start date?

-- Steps To Reproduce:
1)  Upgrade from 6.2SP1 to 7.3.1 (note the bal_grp_mapping_t.sql in the 7.0 upgrade stage script inserts 0 to the valid_from and valid_to fields of the bal_grp_sub_bals_t table)
2)  View upgraded account in customer center
3)  Select Balance tab and click on one of the Resources listed in the Resource data grid.
4)  Displayed valid_from date will show as Dec 31, 1969


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