Index "I_AU_ACCOUNT__ID" Creation Error In Upgrade Script For 6.2 - 7.0

(Doc ID 1051458.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.0.0.0.0 to 7.3.1.0.1 [Release 7.0.0 to 7.3.1]
Information in this document applies to any platform.
***Checked for relevance on 24-Dec-2012***

Symptoms

During upgrade from 6.2 - 7.0 add_new_indexes_70.sql runs first in the SQL_OFFLINE3 listing this
creates the i_au_account_t__parent_obj_id0 index on the au_parent_obj_id0 field on the
au_account_t table.

Then, 62_70_default_values.sql script executes next. This script looks for an index of
i_au_account__id on the au_account_t table referencing the au_parent_obj_id0 field which does not
exist so it tries to create it. This generates an error in the upg_log_t table because this column has an
existing index at that point with a different name.

In OOB it is observed that the i_au_account__id is the index on this table and field.

This is an upgrade from 6.2SP1 - 6.2SP4 - 7.0, partial steps to overall upgrade to 7.3.1.

Steps to Reproduce

Upgrade from 6.2SP1 - 7.0
Review the upg_log_t table for msg_type = 'E'
Should see one indicating step_name = populating_audit_tables and an oracle error message of ORA-01408: such column list already indexed

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