Index "I_AU_ACCOUNT__ID" Creation Error In Upgrade Script For 6.2 - 7.0 (Doc ID 1051458.1)

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 out-of-box, 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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.