Extending the STG_PRODUCT_MASTER Table to Hold 20 Levels

(Doc ID 2317539.1)

Last updated on OCTOBER 20, 2017

Applies to:

Oracle Financial Services Data Foundation - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

In Oracle Financial Services Data Foundation (FSDF) 8.0, can you extend the STG_PRODUCT_MASTER table to hold 20 levels?

You use a combination of EPM (PFT, FTP, ALM) applications and ERM (LRM, GL Recon, Basel) applications and you want to keep data consistent between the ERM and EPM tables.

The seeded EPM SCD 128 loads up to 20 levels into DIM_PRODUCT .

The seeded ERM SCD 78, which uses STG_PRODUCT_MASTER to load to DIM_PRODUCT, should be able to load the same number of levels but STG_PRODUCT_MASTER must be extended to 20 levels first.

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