FTP Outputs Rows to FSI_O_PROCESS_CASH_FLOWS for Day Before As of Date (Doc ID 1380898.1)

Last updated on DECEMBER 07, 2011

Applies to:

Oracle Financial Services Funds Transfer Pricing - 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) 5.6, when you run an FTP Process using a "Cash Flow" (ex. Cash Flow: Duration) method, the cash flow engine is outputting an interest cash flow (FE 430) value to FSI_O_PROCESS_CASH_FLOWS on the day before the As of Date.  You expect the first interest cash flow to occur at the Next Payment Date and for the Next Payment Date to be after the As of Date.  You do not expect to see any rows for the day before the As of Date because there is no cash flow event on that date.

Example:

In Application Preferences, the As of Date = 9/30/2010.

In FSI_O_PROCESS_CASH_FLOWS, there are rows with CASH_FLOW_DATE = 9/29/2010 and a balance exists in the FLOAT_VALUE column for FINANCIAL_ELEM_ID = 430.

Steps to Reproduce:
  1. Go to Funds Transfer Pricing
  2. Go to FTP Processing > Standard Process
  3. Create and run an FTP process that uses a Cash Flow TP Method and has the Audit Option of Detailed Cash Flows selected.
When you review the rows in FSI_O_PROCESS_CASH_FLOWS, you see rows on AS_OF_DATE-1.

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