ORA-01408 Creating "I_SNAP$" Index on FEM_BAL_NACC_HIER_L2_MV (Doc ID 1493217.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle Enterprise Performance Foundation - Version 12.1.1 and later
Information in this document applies to any platform.
Corporate Performance Management Intelligence (CPMI)

Symptoms

For Enterprise Performance Foundation (FEM), you receive the following error creating the unique index I_SNAP$_FEM_BAL_NACC_HIER_1 on the materialized view FEM_BAL_NACC_HIER_L2_MV:

SQL> CREATE UNIQUE INDEX "APPS"."I_SNAP$_FEM_BAL_NACC_HIER_1" ON "APPS"."FEM_BAL_NACC_HIER_L2_MV" (
 2 SYS_OP_MAP_NONNULL("LEDGER_ID"),
 3 SYS_OP_MAP_NONNULL("DATASET_CODE"),
SYS_OP_MAP_NONNULL("CAL_PERIOD_ID"),
SYS_OP_MAP_NONNULL("CURRENCY_CODE"),
SYS_OP_MAP_NONNULL("COMPANY_COST_CENTER_ORG_ID"),
SYS_OP_MAP_NONNULL("COMPANY_COST_CENTER_ORG_VS_ID"),
SYS_OP_MAP_NONNULL("VALUE_SET_ID"),
SYS_OP_MAP_NONNULL("OBJECT_ID"),
SYS_OP_MAP_NONNULL("OBJECT_DEFINITION_ID"),
SYS_OP_MAP_NONNULL("LEVEL1_ID"),
SYS_OP_MAP_NONNULL("LEVEL2_ID")
)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_DATA" ; 4 5 6 7 8 9 10 11 12 13 14 15 16 17
SYS_OP_MAP_NONNULL("LEDGER_ID"),
*
ERROR at line 2:
ORA-01408: such column list already indexed


The error prevents you from creating the unique index.

You already removed the duplicate column for VALUE_SET_ID as described in <Document 1284055.1> "Patch Fails on Fem_bal_nacc_hier_l2_mv.xdf After Upgrade to Oracle 11.2.0.2 Database".

Note: These objects are used by the Corporate Performance Management Intelligence (CPMI) reports.

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