FTP Assumptions Report Transfer Pricing Methods Are Not Displaying for All Products Defined (Doc ID 1951182.1)

Last updated on DECEMBER 04, 2014

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On Oracle Financial Services Asset Liability Management Analytics (ALMBI) 6.1, the FTP Assumptions report does not show the records for any products defined at the node level or a TP method not attached to an TP IRC like Spread from Note Rate method.

ACTUAL BEHAVIOR
The FTP Assumptions Report-Transfer Pricing does not show all defined assumptions for all Product IDs. The results are not available in the TP reports for certain records. For example, records for product_id 15001 and 15002 of FSI_D_Loan_Contracts are not available though other records of the table are available in the reports.

The issue appears to be for products with TP methods defined at the node level or those with TP methods not attached to IRCs like 'Spread from Note Rate'.

EXPECTED BEHAVIOR
Expect to see all defined methods for all products.

The issue can be reproduced at will with the following steps:

1. Executed the FTP process.
2. Executed SCD process
3. Executed Dim_Run process
4. Executed process to populate Fct_Common_Account_Summary
5. Executed process to populate Fct_FTP_Account_Summary

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