Cash Flow Edits Does Not Output Rows for All Tables in FSI_PROCESS_ERRORS (Doc ID 1325318.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version: 5.2 and later   [Release: 5 and later ]
Oracle Financial Services Asset Liability Management - Version: 5.2 and later    [Release: 5 and later]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Funds Transfer Pricing (FTP) or Asset Liability Management (ALM), when you run a Cash Flow Edits rule against multiple tables, you do not get output in FSI_PROCESS_ERRORS for all of the tables.  Rows are only created for the first few tables. 

You ran the following query to check the tables processed:

select distinct table_name from fsi_process_errors where process_sys_id = <System ID of CF Edits Rule>;

Not all selected tables are returned.

Steps to Reproduce:
  1. Go to Funds Transfer Pricing
  2. Go to FTP Processing > Cash Flow Edits
  3. Create a Cash Flow Edits rule with Preview Mode selected that selects multiple tables
  4. Run the Cash Flow Edits rule
FSI_PROCESS_ERRORS only contains rows from some of the tables selected in the 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