Table FSI_D_MORTGAGES Failed. Validate Instrument. No Valid Unique Index Found in FSI_MESSAGE_LOG (Doc ID 1146994.1)

Last updated on AUGUST 19, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Object Registration And Validation - Batch_Table_Class_Req

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