Extending the STG_PRODUCT_MASTER Table to Hold 20 Levels
(Doc ID 2317539.1)
Last updated on JUNE 03, 2021
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.
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