My Oracle Support Banner

Function STG_DIMENSION_LOADER.STG_DATALOADER Not Updating Null Attribute Value of V_LEVEL1_PROD_DESC (Doc ID 2609772.1)

Last updated on MAY 19, 2021

Applies to:

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

Goal

Function stg_dimension_loader.stg_dataLoader is not updating the attribute value in the table DIM_PRODUCTS_ATTR for the null value. If the value is other than null then it updates the value.

The merge statement like below:

merge into DIM_PRODUCTS_ATTR target_table
using (
select
bb.PRODUCT_ID id_column,5558 attribute_id
,aa.V_LEVEL1_PROD_DESC attr_val
from stg_product_master aa
, DIM_PRODUCTS_B bb
where
fic_mis_date = to_date('20181231','RRRRMMDD')
and aa.V_LEVEL1_PROD_DESC is not null
and aa.v_prod_code = bb.PRODUCT_CODE
...

In which the condition as "and aa.V_LEVEL1_PROD_DESC is not null"
 

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.