How to Consolidate BSP Results by Reporting Currency from BSP Cash Flow ? (Doc ID 2272919.1)

Last updated on JUNE 19, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.2.0.8 and later
Information in this document applies to any platform.
Oracle Financial Services Balance Sheet Planning (BSP)

Goal

How to create Cons_DTL_XXX (Consolidation by Reporting Currency) table from BSP Cash Flow ?  Currently have millions of records in various instrument tables with data in different currencies. However it is required to have all results in a single functional currency.  It is not required to have currency wise cash flows. How to get result data converted into functional currency before loading into the cube?

Solution

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