Index "I_AU_ACCOUNT__ID" Creation Error In Upgrade Script For 6.2 - 7.0
(Doc ID 1051458.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Communications Billing and Revenue Management - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Dec-2012***
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document