Base TP Rate and Charge Credit Trate in ALMBI FTP Margin Super Report is Not Populated Correctly (Doc ID 2268079.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 8.0.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Business Intelligence Enterprise Edition (OBIEE)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)
ALM BI
Reporting
FTP Reports

Symptoms

On ALBI 8.0.1, the Charge Credit Trate in FTP Margin Super Report is not populated correctly .

ACTUAL BEHAVIOR

When checking the transfer price margin super report rate in FTP BI and filter charge credit from drop down Rate/ charge credit amount section it does the following:

When the filter is set to `All In Rate` it computes weighted average transfer rate of all the accounts under a particular product and populates it.
When the filter is set to `Charge credit amount' it takes the charge credit T rate of the account that has lowest cur book bal and populates it. The system ignores all other accounts associated within that product (have tied multiple accounts in a product)

In FCT_FTP_ACCOUNT_SUMMARY all the records at account level that we processed have appeared with expected numbers.
Even if filtering the result are same because we have the records in same org, currency and legal entity level.

In BI results are at product level so when there is more than one account in a particular product it should ideally be doing weighted average and populate as it is doing in case of TP Rate (provided all in t rate is computed which is another issue), but in the case of charge credit it is picking the account that has lowest balance and populating it against the product ignoring all other account values.

In addition to above please note the following observations in the same report:

Charge Credit Amount is blank though charge credit T rate is populated (though incorrect as stated in paragraph 2). Have checked the query which mention charge credit amount is Charge credit T rate + other adjustments. In this case, charge credit T rate and other value null. The system is doing value + null - null. Believe this should also be changed to value + 0 = value. It should not be null because other adjustments are null.

The issue can be reproduced at will with the following steps:
1. Check the values output in the FTPBI transfer price margin super 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