My Oracle Support Banner

Performance Slow Down With Missing Indexes While Running PCM_OP_CUST_DELETE_ACCT (Doc ID 2621380.1)

Last updated on FEBRUARY 08, 2024

Applies to:

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

Goal

The user is observing Performance slow down with missing indexes while deleting accounts using out of box opcode PCM_OP_CUST_DELETE_ACCT. 

As per Business Requirement, Opcode “PCM_OP_CUST_DELETE_ACCT” is being used to delete the data for specific accounts. The delete is having performance issue and taking a longer time. It is found that issue is with below out of the box tables with missing index on the field “obj_id0”.

EVENT_AUDIT_COLL_GDTLS_T – Index required on the field “obj_id0”.
EVENT_CUSTOMER_PHONES_T - Index required on the field “obj_id0”.
INVOICE_T.ACCOUNT_OBJ_ID0

Will it improve the performance, if one creates the indexes on these event tables?

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.