Invalid Index During Direct Path Loading In REL
Last updated on SEPTEMBER 26, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 184.108.40.206.0 to 220.127.116.11.1 [Release 7.0.0]
HP-UX PA-RISC (32-bit)
Checked for relevance on 01-Jun-2012.
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 :
=ORA-01502: index 'PIN.I_EVENT_BI_ITEM_OBJ__ID' or partition of such index is in
Steps To Reproduce
Try to load a large number of files via REL using SQLLDR "direct path".
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