Table FSI_D_MORTGAGES Failed. Validate Instrument. No Valid Unique Index Found in FSI_MESSAGE_LOG

(Doc ID 1146994.1)

Last updated on FEBRUARY 22, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Oracle Financial Services Asset Liability Management - Version 6.1 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Oracle Financial Services Profitability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Object Registration And Validation - Batch_Table_Class_Req
Instrument Table Validation

Symptoms

In Oracle Financial Services Analytical Applications Infrastructure (OFSAAI), after you run the Batch_Table_Class_Req task to classify tables, you see table classification errors like the following in the table <atomic schema>.FSI_MESSAGE_LOG:

Instrument table example:

Table FSI_D_MORTGAGES ( 310)
HINT: Last query executed was - SELECT index_name FROM all_indexes WHERE table_owner =  'ATOMIC' AND table_name = 'FSI_D_MORTGAGES' AND uniqueness = 'UNIQUE'
" Failed: Table Property 1010 - Validate Instrument.
        Table:FSI_D_MORTGAGES. No valid unique index found"
HINT: check_table_class_req procedure returned status N while validating table FSI_D_MORTGAGES for classification code 310
Table FSI_D_MORTGAGES Failed (310)

Transaction table example:

Table FSI_D_RETIREMENT_ACCTS_TXNS ( 300)
FAILED: Table Property 1020 - Validate Transaction Key No valid unique index found
Table did not meet stored procedure requirements.Table: FSI_D_RETIREMENT_ACCTS_TXNS
Table FSI_D_RETIREMENT_ACCTS_TXNS Failed (300)

These errors occur for some or all instrument and transaction tables.

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