My Oracle Support Banner

Can Dimension Data Be Transferred from STG_PRODUCT_MASTER into the STG_PRODUCTS_B/TL/ATTR/HIER_INTF? (Doc ID 2503576.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Hedge Management and IFRS Valuations - 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 Analytical Applications (OFSAA), your applications require population of both STG_PRODUCT_MASTER and the STG_PRODUCTS_B_INTF, STG_PRODUCTS_TL_INTF, STG_PRODUCTS_ATTR_INTF, and STG_PRODUCTS_HIER_INTF.

For example, you need to populate the Staging B/TL/ATTR/HIER tables to load multiple hierarchies for applications like FTP, PFT, and ALM.  You need to populate STG_PRODUCT_MASTER to meet requirements for applications like LLFP.

Is there a post load transformation or program that will transfer data from STG_PRODUCT_MASTER into STG_PRODUCTS_B/TL/HIER_INTF or vice versa - transfer data from STG_PRODUCTS_B/TL/HIER_INTF into STG_PRODUCT_MASTER?

Solution

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
Goal
Solution
References


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