W_INT_ORG_DH Table not getting populated from W_INT_ORG_DHS

Question

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

Venkata Yaswanth Ramisetty · Answer

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

Thomas Dodds · Answer

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

Vivek.kumar · Answer

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.