BRM 7.5PS12 Upgrade Script Failing With ORA-14024 (Doc ID 2073520.1)

Last updated on MAY 23, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Goal

On : 7.5.0.12.0 version, Infranet Install

Errors as below when running the upgrade script " ./pin_75_75ps12_upgrade.pl":

Console output:
---------
filename is /u02/ecebrmpdc/brm12/opt/portal/7.5/sys/dd/data/create_index_event_billing_product.source
Started create_index_event_billing_product.source at Fri Oct 30 11:23:38 2015 .....
Execute SQL statement from file /u02/ecebrmpdc/brm12/opt/portal/7.5/sys/dd/data/create_index_event_billing_product.source
Execution is unsuccessful for create_index_event_billing_product.source
Execution failed for default_values_75ps6(). Please see the respective log file at /u02/ecebrmpdc/brm12/opt/portal/7.5/tmp

Log file:
---------
ORA-20001: INDEX CREATION FAILED FOR I_EVENT_BILLING_PROD_OBJ__ID
ORA-14024: number of partitions of LOCAL index must equal that of the underlying table
ORA-06512: at line 23
ORA-14024: number of partitions of LOCAL index must equal that of the underlying table

How to solve the ORA-14024 when running pin_75_75ps12_upgrade.pl? 

Solution

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