How to Determine Columns Required for OFSAA Table Classifications (Doc ID 1293179.1)

Last updated on MARCH 04, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.1 and later
Oracle Financial Services Funds Transfer Pricing - Version 5.1 and later
Oracle Financial Services Asset Liability Management - Version 5.1 and later
Oracle Financial Services Profitability Management - Version 5.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), when you run the Batch_Table_Class_Req program to classify a new or user defined table for use in Funds Transfer Pricing (FTP), Asset Liability Management (ALM) or Profitability Management (OFSPM), the table fails the classification.  (In earlier versions, when a table was missing columns, the FSI_MESSAGE_LOG messages only indicated the classification failed and did not list any details.)

How can you determine which columns are required to classify a table successfully for one of the classifications listed below?

Below are some examples of table classifications:

Instrument Profitability (Allocation)
Transaction Profitability (Transaction Allocation)
TP Cash Flow
TP Non-Cash Flow
TP Option Costing
ALM Standard

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