Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

W_INT_ORG_DH Table not getting populated from W_INT_ORG_DHS

Received Response
3
Views
4
Comments
Vivek.kumar
Vivek.kumar Rank 2 - Community Beginner
in Oracle Business Intelligence Applications

Hello Everyone,

I am running OBIA recruitment offering to load warehouse from PeopleSoft. After complete data load we came to know that there is no data in hierarchy table W_INT_ORG_DH we backtrack the issue and found that W_INT_ORG_DHS have data but SILOS interface to load W_INT_ORG_DH table is not loading data in table.

After taking the query and analyzing we found that there is one join condition applied i.e. W_INT_ORG_DHS.BASE_ORG_NUM = W_INT_ORG_D.INTEGRATION_ID due to which no records is fetched by mapping.

After investigating it further we found that value in these columns are completely different.

In W_INT_ORG_DHS table BASE_ORG_NUM is like NODE~DEPARTMENT~COMMN~%

while In W_INT_ORG_D table INTEGRATION_ID is like DEPARTMENT~COMMN~%.

So what wrong is happening whether W_INT_ORG_DHS is getting wrongly populated or we would have some extra records in W_INT_ORG_D table to match with DHS table.

Thanks & Regards,

Vivek Kumar

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Did you check Oracle support for a fix for this?  or you could follow the documented approach to customization and add NODE~ to your integration id.  Don't just make the change in the base code follow the documented customization paths.

  • Vivek.kumar
    Vivek.kumar Rank 2 - Community Beginner

    Thanks for your reply.

    I am not sure if there is any bug fix or it is something we are doing wrong, I checked on oracle support site and did not see any bug related to this. Once I get assured from my side that it is bug then I can raise a ticket to correct it.

    In documentation I checked the functional configuration documentation and all the information that is required to configure hierarchy is already done and it is populating DHS table correctly. It will be really helpful if you can provide some documentation link where I can check if there is anything to customize. 

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    A quick google search shows multiple blogs and the links to documentation ...

  • Venkata Yaswanth Ramisetty
    Venkata Yaswanth Ramisetty Rank 5 - Community Champion

    Hi,

    Can you check the source column from where the BASE_ORG_NUM and INTEGRATION_ID are getting populated. One possibility will be in source the column might have different data. If that's not the case, the domain mapping needs to be done from our end in BIACM to make sure that the both columns are identical.

    Have you done with domain configurations? If so, can you tell us the value specified for this department specific domain values.

    Thanks,

    Yaswanth