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

Last updated on MARCH 10, 2023

Applies to:

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

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