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

Last updated on APRIL 25, 2017

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)

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.

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