Extending the STG_PRODUCT_MASTER Table to Hold 20 Levels
Last updated on FEBRUARY 09, 2018
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)
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.
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