My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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