My Oracle Support Banner

LRM BI Reports ->Funding Concentration Reports Significant Currency Filter is fetching only two currencies (Doc ID 2609489.1)

Last updated on NOVEMBER 14, 2019

Applies to:

Oracle Financial Services Liquidity Risk Management - Version 8.0.0 and later
Information in this document applies to any platform.

Goal

To provide resolution on data resulting only two currencies in Funding Concentration Reports in Significant Currency filter, using Outflow Amount Reporting Currency/Local Currency from Aggregate Cash Flow Facts table,

1. If OOB report can use the Inflow Amount Reporting Currency/Local currency to get the better significant currency filter values.

(case when ASCII('@{Currency}{Reporting Currency}') =ASCII('Reporting
Currency') then "Aggregate Cash Flow Facts"."Outflow Amount Reporting
Currency"/SUM("Aggregate Cash Flow Facts"."Outflow Amount Reporting
Currency") else "Aggregate Cash Flow Facts"."Outflow Amount Local
Currency"/SUM("Aggregate Cash Flow Facts"."Outflow Amount Local Currency")
end)>0.05

2. Remove the condition here 0.05(5%) from funding concentration reports.
 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.