My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution

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