OBIA 11g Join Between Dim_W_INT_ORG_D_Inventory_Org And Fact_W_PRODUCT_LOT_XACT_F Does Not Appear to be Set Correctly
Last updated on JANUARY 26, 2018
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.1 and later
Information in this document applies to any platform.
There seems to be an issue regarding the join between Dim_W_INT_ORG_D_Inventory_Org and Fact_W_PRODUCT_LOT_XACT_F.
In the standard OBIA 18.104.22.168 RPD, the join condition is
"Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_INT_ORG_D_Inventory_Org"."ROW_WID" = "Oracle Data Warehouse"."Catalog"."dbo"."Fact_W_PRODUCT_LOT_XACT_F"."INVENTORY_ORG_WID"
At the ODI level INVENTORY_ORG_WID is populated based on SCD1_WID column from W_INT_ORG_D table. Because of this join mismatch between ODI and RPD, when you execute the query below you getting no results.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms