Invalid Index During Direct Path Loading In REL

(Doc ID 781169.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.0.0]
HP-UX PA-RISC (32-bit)
Checked for relevance on 01-Jun-2012.


Problem Statement

During REL execution in BRM 7.0, error messages being reported by various componenets of the application in the cm.pinlog indicating INVALID indexes on one of the EVENT_* tables. This has been traced to the direct path load option for IREL.

For example, in dm_oracle pinlog :

ORACLE error: do_sql_mr_select: OCIStmtExecute: code 1502, op -1
=ORA-01502: index 'PIN.I_EVENT_BI_ITEM_OBJ__ID' or partition of such index is in
unusable state

Steps To Reproduce

Try to load a large number of files via REL using SQLLDR "direct path".

Business Impact

High number of transactions, including billing, payments, and orders get rejected due to this issue at various times throughout the day.


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