Change Access to Item Object to No Longer Rely on Index I_ITEM_BAL_GRP__ID (Doc ID 2093907.1)

Last updated on JULY 27, 2017

Applies to:

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

Symptoms

On : 7.5.0.10.0 version, Core Billing

ACTUAL BEHAVIOR
---------------
Customer has business requirements to drop the index I_ITEM_BAL_GRP__ID as it uses a lot of data base storage.
To facilitate this any access to the item table should add the account obj as well as the bal_grp obj.


EXPECTED BEHAVIOR
-----------------------
Change access to item object to no longer rely on index I_ITEM_BAL_GRP__ID


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
The index is using up a lot of data storage space and is not really used. Customer wants to drop this index, but the code is relying on it.

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