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 and later
Information in this document applies to any platform.


On : version, Core Billing

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.

Change access to item object to no longer rely on index I_ITEM_BAL_GRP__ID

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.


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