After running Domain LP Domain member mappings are not visible in BIACM

Question

HI

BIAPPS rel 11.1.1.10.2

Please advise

Thanks

Prateek

User_M1NI3 · Answer

Hi Yaswanth,

I have similar question. I want to bring one of the lookup type VALUES from FND_LOOKUP_VALUES.

I have added the lookup type as a source domain, and executed the domain load. I am not seeing any values.

Could you please help me where i am doing wrong.

Venkata Yaswanth Ramisetty · Answer

Hi Prateek,

Do you mean that you are unable to view the domain members?

If we run the domain load, all the source domains and warehouse domains will be loaded into W_DOMAIN_MEMBER_G table. We need to go to BIACM and then map the source and target values accordingly and then after saving, corresponding mapped data will be loaded in W_DOMAIN_MEMBER_MAP_G.

If there are no source and warehouse values at all, then consider a single domain code and then check the ODI logic why the corresponding members are not picked and loaded to W_DOMAIN_MEMBER_G table .

Hope this helps.

Regards,

Yaswanth