FAILED: Table Property 1020 - Validate Transaction Key. Object: FSI_D_<tbl>_TXNS. Invalid Processing Key Column Properties. (Doc ID 1572175.1)

Last updated on MAY 24, 2024

Applies to:

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), when you run the Table Classification program Batch_Table_Class_Req in a batch, you get the following errors on a transaction table FSI_D_<table>_TXNS in FSI_MESSAGE_LOG:

Table FSI_D_CASA_TXNS ( 300)
Hint1: Table - FSI_D_CASA_TXNS. Columns in table that has column_property_cd of 15 is 7
Hint2: Table - FSI_D_CASA_TXNS. Columns in table that are part of unique index  FSI_D_CASA_TXNS is 3
FAILED:  Table Property 1020 - Validate Transaction Key. Object: FSI_D_CASA_TXNS. Invalid Processing Key Column Properties.
HINT: check_table_class_req procedure returned status N while validating table FSI_D_CASA_TXNS for classification code 300
Table FSI_D_CASA_TXNS Failed (300)

The error prevents you from classifying the table as "Transaction Profitability" for use in Profitability Management.

Changes

Cause

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