EPB – OGL step 2: Set the Unique Index on FEM_BALANCES

Categories: Other

In this task you create a unique index on FEM_BALANCES that includes the dimensions and columns above.

Navigation: Log into the Oracle Applications database as ‘apps’ through SQL*Plus.

    

DROP INDEX FEM.FEM_BALANCES_P;
CREATE UNIQUE INDEX FEM.FEM_BALANCES_P
ON FEM.FEM_BALANCES
(CAL_PERIOD_ID,
COMPANY_COST_CENTER_ORG_ID,
CREATED_BY_OBJECT_ID,
CURRENCY_CODE,
CURRENCY_TYPE_CODE,
DATASET_CODE,
FINANCIAL_ELEM_ID,
LEDGER_ID,
LINE_ITEM_ID,
NATURAL_ACCOUNT_ID,
SOURCE_SYSTEM_CODE,
PROJECT_ID,
CHANNEL_ID,
CUSTOMER_ID,
USER_DIM1_ID,
User_dim2_id)
TABLESPACE FEMX
STORAGE (MAXEXTENTS UNLIMITED);

 flex_structure.png

« « Oracle EPB – OGL step 1: Grant Access to the Security Folders                        EPB – OGL step 3: Set the Processing Key on FEM_BALANCES » »

Comments are closed.