Problem Running Pin_Rel After Installing 7.4 PS7 (Doc ID 1320278.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
Information in this document applies to any platform.
checked for relevance on 22-Sep-2013.

Symptoms

After installing BRm 7.4 PS7 the following error occurs when processing GPRS files:

ORA-26017: global indexes not allowed for direct path load of table partition PIN.EVENT_DLYD_SESSION_TLCO_GPRS_T

DB side error:
-------------------------------------------------------
ORA-26017: global indexes not allowed on direct path partition load, table name
Cause: Global indexes are defined on a table when direct path loading a single partition of the table.
Action: Remove the global index from the named table and retry the operation.
----------------------------------------------------------

The problem seems to be caused by the index : I_EVENT_DLAY_SS_TLCOGPRS__ID created during the installation of PS7.

Cause

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