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 JANUARY 23, 2020

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 5.2 and later
Oracle Financial Services Asset Liability Management - Version 5.2 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.