My Oracle Support Banner

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.


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.

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.

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:

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

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


To view full details, 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 a vibrant support community of peers and Oracle experts.