BSP 8.0 Missing Instrument Table Indexes (Doc ID 2054238.1)

Last updated on MARCH 02, 2016

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.0 to 8.0.1 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

Instrument table indexes are missing from BSP 8.0 installation in comparison to BSP 6.0.

The following are indexes in BSP 6.0 that are not in BSP 8.0.

INDEX_NAME TABLE_NAME
DETAIL_RECORD_CD_PK FSI_DETAIL_RECORD_CD
DETAIL_RECORD_MLS_PK FSI_DETAIL_RECORD_MLS
FSI_D_MORTGAGE_BACK_SEC FSI_D_MORTGAGE_BACK_SEC
IDX_FSI_D_MORTGAGE_BACK_SEC_2 FSI_D_MORTGAGE_BACK_SEC
IDX_FSI_D_MORTGAGE_BACK_SEC_3 FSI_D_MORTGAGE_BACK_SEC
IDX_FSI_D_MORTGAGE_BACK_SEC_4 FSI_D_MORTGAGE_BACK_SEC
IDX_FSI_D_MORTGAGE_BACK_SEC_5 FSI_D_MORTGAGE_BACK_SEC
IDX_FSI_D_MORTGAGE_BACK_SEC_6 FSI_D_MORTGAGE_BACK_SEC
IDX_FSI_D_MORTGAGE_BACK_SEC_7 FSI_D_MORTGAGE_BACK_SEC
IDX_FSI_D_MORTGAGE_BACK_SEC_8 FSI_D_MORTGAGE_BACK_SEC
IDX_FSI_D_MORTGAGE_BACK_SEC_9 FSI_D_MORTGAGE_BACK_SEC
PK_FSI_DATA_IDENTITY FSI_DATA_IDENTITY
PK_FSI_DATA_SLICE_TYPE_CD FSI_DATA_SLICE_TYPE_CD
PK_FSI_DATA_SLICE_TYPE_MLS FSI_DATA_SLICE_TYPE_MLS
PK_FSI_DATA_SOURCE_CD FSI_DATA_SOURCE_CD
PK_FSI_DATA_SOURCE_MLS FSI_DATA_SOURCE_MLS
PK_FSI_DATA_TYPE_DESC FSI_DATA_TYPE_DESC
PK_FSI_DB_INFO FSI_DB_INFO
PK_FSI_DELINQUENCY_STATUS_CD FSI_DELINQUENCY_STATUS_CD
PK_FSI_DELINQUEN_STATUS_MLS FSI_DELINQUEN_STATUS_MLS
PK_FSI_D_EMBEDDED_OPTIONS FSI_D_EMBEDDED_OPTIONS
PK_FSI_D_EMBEDDED_OPTIONS_SCH FSI_D_EMBEDDED_OPTIONS_SCH
PK_FSI_DEPOSIT_TYPE_CD FSI_DEPOSIT_TYPE_CD
PK_FSI_DEPOSIT_TYPE_MLS FSI_DEPOSIT_TYPE_MLS
PK_FSI_DERIVATIVE_SUB_TYPE_CD FSI_DERIVATIVE_SUB_TYPE_CD
PK_FSI_DERIVATIVE_SUB_TYPE_MLS FSI_DERIVATIVE_SUB_TYPE_MLS
PK_FSI_DERIVATIVE_TYPE_CD FSI_DERIVATIVE_TYPE_CD
PK_FSI_DERIVATIVE_TYPE_MLS FSI_DERIVATIVE_TYPE_MLS
PK_FSI_DEVOLVEMENT_STATUS_CD FSI_DEVOLVEMENT_STATUS_CD
PK_FSI_DEVOLVEMENT_STATUS_MLS FSI_DEVOLVEMENT_STATUS_MLS
PK_FSI_DIH_METHOD_CD FSI_DIH_METHOD_CD
PK_FSI_DIH_METHOD_MLS FSI_DIH_METHOD_MLS
PK_FSI_DIM_ATTRIBUTE_MAP FSI_DIM_ATTRIBUTE_MAP
PK_FSI_DIR_DEPOS_ACCT_TYPE_CD FSI_DIR_DEPOS_ACCT_TYPE_CD
PK_FSI_DIR_DEPOS_ACCT_TYPE_MLS FSI_DIR_DEPOS_ACCT_TYPE_MLS
PK_FSI_DIRECT_IND_CD FSI_DIRECT_IND_CD
PK_FSI_DIRECT_IND_MLS FSI_DIRECT_IND_MLS
PK_FSI_DISBURS_METHOD_CD FSI_DISBURS_METHOD_CD
PK_FSI_DISBURS_METHOD_MLS FSI_DISBURS_METHOD_MLS
PK_FSI_DISCOUNT_RATE_METHOD_CD FSI_DISCOUNT_RATE_METHOD_CD
PK_FSI_DISTRIBUTION_CHANNEL_CD FSI_DISTRIBUTION_CHANNEL_CD
PK_FSI_DOCUMENTATION_CD FSI_DOCUMENTATION_CD
PK_FSI_DOCUMENTATION_MLS FSI_DOCUMENTATION_MLS
PK_SI_DIM_LOADER_SETUP_DETAILS FSI_DIM_LOADER_SETUP_DETAILS
PK_SI_DISCOUNT_RATE_METHOD_MLS FSI_DISCOUNT_RATE_METHOD_MLS
PK_SI_DISTRIBUTION_CHANNEL_MLS FSI_DISTRIBUTION_CHANNEL_MLS

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