ALMBI TP Super Margin Report Does Not Contain Expected Results and Shows Blank Values (Doc ID 2014662.1)

Last updated on FEBRUARY 01, 2017

Applies to:

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

Symptoms

On Oracle Financial Services Asset Liability Management Analytics (ALMBI) 8.0.0, the TP Super Margin Report does not contain expected results / Blank values.
 
ACTUAL BEHAVIOR
Have executed the T2T's to load data to the Fact Common Account Summary and FTP Account Summary and the process was successful. The Instrument tables are populated with the correct data, however the TP Super margin report is missing Charge Records for the Checking Accounts, Money Market Accounts, Commercial Loans Floating, Commercial Loans Fixed, Total Retails Mortgages Floating. For each one of the mentioned instrument classes we have values populated.

EXPECTED BEHAVIOR
Expect all instrument type values to have correct results in the report.

The issue can be reproduced at will with the following steps:
1. Display TP Super margin report

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