'No Valid Unique Index Found' When Classifying a View in OFSAA (Doc ID 1668731.1)

Last updated on MAY 08, 2024

Applies to:

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), when you run the Table Classification program Batch_Table_Class_Req, you get the following errors when classifying a view:

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

and

Table TST_CONSUMER_LOAN_VW1 ( 330)
HINT: Last query executed was - SELECT N1.index_name FROM all_indexes N1 WHERE N1.table_owner =  'ATOMIC' AND N1.table_name = 'CONSUMER_LOA' AND N1.uniqueness = 'UNIQUE' AND N1.index_name not in (SELECT C2.index_name FROM user_updatable_columns U2, all_ind_columns C2 WHERE U2.table_name = 'TST_CONSUMER_LOAN_VW1' AND C2.table_name = 'CONSUMER_LOA' AND C2.table_owner = 'ATOMIC' AND C2.column_name = U2.column_name AND U2.updatable = 'NO')
" Failed: Table Property 1030 - Validate Correction Key.
Table:CONSUMER_LOA. No valid unique index found"
HINT: check_table_class_req procedure returned status N while validating table TST_CONSUMER_LOAN_VW1 for classification code 330
Table TST_CONSUMER_LOAN_VW1 Failed (330)

In the SQL listed with the error, the name of the base table used to create the view has its last letter truncated.  In the example above, the view TST_CONSUMER_LOAN_VW1 is created from the base table CONSUMER_LOAN but the name is truncated to CONSUMER_LOA in the SQL.

The error does not occur for all views but does prevent you from classifying certain views successfully.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.