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:
Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and laterInformation 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.
Changes
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 |
Changes |
Cause |
Solution |