My Oracle Support Banner

What Is the Purpose or Design for Use of STRATEGY_ID in FSI_D_MANAGEMENT_LEDGER in 8.1.x Releases (Doc ID 2786458.1)

Last updated on JUNE 25, 2021

Applies to:

Oracle Financial Services Profitability Management - Version and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)


Question 1: What is the purpose/design for use of STRATEGY_ID in FSI_D_MANAGEMENT_LEDGER / Management Ledger tables?  From previous release information provided:

Column "STRATEGY_ID" was added to the data model to support integration with Oracle Financial Services Balance Sheet Planning (BSP). While the column is added to the data model, STRATEGY_ID will not be registered as a key dimension as long as BSP is not installed. Installing BSP will register it as a key dimension.

Until BSP is installed, PFT should continue to work as if this column never existed. The column should default to a value of -1.

Though this could have been true for prior versions of OFSAA where compartmentalization of a particular module wasn't that visible. Now, with OFSAA 8.1+ approach, it seems like the product wants to completely segregate the individual modules from each others, even to the extent of taking out DIM reporting tables out of the PFT installer as they are part of Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI).

If that is true, and if strategy id was designed to be applicable for BSP, why is there a super child sub-child relation for strategy id in PFT 8.1.1 Data Model and why is the column even existing in PFT if it is supposed to be vestigial.
Question 2: If strategy_id is not required in 8.1.x releases, how to remove STRATEGY_ID from Management Ledger?


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

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