Change Access to Item Object to No Longer Rely on Index I_ITEM_BAL_GRP__ID
(Doc ID 2093907.1)
Last updated on APRIL 01, 2019
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
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 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
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
| Symptoms |
| Cause |
| Solution |
| References |