Cash Flow Edits Not Running for FSI_D_CAPFLOORS and FSI_D_SWAPS Due to Missing Columns Errors (Doc ID 2245429.1)

Last updated on MAY 04, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Oracle Financial Services Asset Liability Management - Version 6.1 and later
Information in this document applies to any platform.

Symptoms

On ALM 6.1.1, when attempting to run cash flow edits in preview mode on all the instrument tables, after execution, there are no rows in the FSI_PROCESS_ERRORS table.  No error is found in the ofsbc debug log.

ACTUAL BEHAVIOR
Executing cash flow edits in preview mode. no results are generated in fsi_process_errors. Works if only single table like Loan Contracts is selected.

EXPECTED BEHAVIOR
Expect results to be written to the FSI_PROCESS_ERRORS table upon execution.

During debugging, after running the Cash Flow Edit from the command line as per <Document 1537000.1> How to Run Oracle Financial Services Analytical Applications(OFSAA) 6.1, 6.1.1 and 8.0 Process via the Command Line, error is then thrown:

MB(Missing Columns) Table: FSI_D_CAPFLOORS is missing columns:

cur_net_par_bal_c
MB(Missing Columns) Table: FSI_D_SWAPS is missing columns:
cur_net_par_bal_c


The issue can be reproduced at will with the following steps:
1. Create a new Cash Flow Edit rule
2. Select all instrument tables and check Preview mode
3. Run the Cash Flow Edit rule

Cause

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