My Oracle Support Banner

OFSAA PFT Upgrade to 8.0.7 Error:ORA-01408: such column list already indexed for FSI_D_<INSTRUMENT>_AGGR Tables (Doc ID 2534282.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Enterprise Performance Management (EPM)

Goal

After upgrading to PFT 8.0.7, a non fatal error appears in the log file. What is needed to fix this or can it be ignored?

[26-03-19 16:07:18,745 CDT PM] [INFO ] Executing file:/u03/app/ofsaa/scripts/atomic/create/indexes.sql
[26-03-19 16:07:30,571 CDT PM] [ERROR] Query:'--Bug 9833344 - ENH: AGGREGATION FUNCTIONALITY: USER-DEFINED, USER-FRIENDLY UI & ENGINE starts
Declare
 v_cnt_table number;
 v_cnt_index number;
begin
 select count(1)
  INTO v_cnt_table
  from user_tables t
  where t.table_name = 'FSI_D_ANNUITY_CONTRACTS_AGGR';
 SELECT count(1)
  INTO v_cnt_index
  from user_indexes
  WHERE table_name = 'FSI_D_ANNUITY_CONTRACTS_AGGR'
  and INDEX_NAME = 'FSI_D_ANNUITY_CONTRACTS_AGGR';
 IF v_cnt_table = 1 and v_cnt_index != 1 THEN
  EXECUTE IMMEDIATE 'CREATE UNIQUE INDEX FSI_D_ANNUITY_CONTRACTS_AGGR ON FSI_D_ANNUITY_CONTRACTS_AGGR (IDENTITY_CODE, ID_NUMBER)';
 END IF;
END;'
 Error:ORA-01408: such column list already indexed
ORA-06512: at line 16

Solution

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
Goal
Solution
References


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