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 laterInformation 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 |