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 11, 2020

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 OOB 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.