Do You Have to Add User Defined Leaf/Dimension Columns to Transaction Tables? (Doc ID 1545660.1)

Last updated on JULY 20, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Oracle Financial Services Profitability Management - Version 6.1 and later
Oracle Financial Services Asset Liability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

In Oracle Financial Services Analytical Applications (OFSAA) 6.1, when you run the table classification program Batch_Table_Class_Req, you get the following error on a user defined leaf/dimension in FSI_MESSAGE_LOG:

FAILED: Table FSI_D_CASA_TXNS. Leaf Column "<dimension name>" missing or incorrectly registered. Data Type must be NUMBER and FDM Data Type must be LEAF
HINT: check_table_class_req procedure returned status N while validating table FSI_D_CASA_TXNS for classification code 300

The dimension column was missing from the transaction tables prior to version 6.1 but you did not get any error messages for it.

Are you now required to add user defined dimensions to the transaction tables?

Solution

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