FAILED: Table Property 1020 - Validate Transaction Key. Object: FSI_D_<tbl>_TXNS. Invalid Processing Key Column Properties.
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)
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.
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