Where is Employee Nationality column in data warehouse for OBIAPPS 18.104.22.168.1 ? As for BI APPS 22.214.171.124 Nationality column is available in W_EMPLOYEE_D table but in new version OBI APPS 126.96.36.199.1 we are not able to find NATIONALITY Column in W_EMPLOYEE_D.
OS: windows 2008 R2
BI APPS: 188.8.131.52.1
Thanks for your feedback. Can i find EMPLOYEE NATIONALITY column in W_HR_PERSON_LEG_D ?
one more thing in our case we are having 4 Different Business groups and these Business groups are having Different legislation per country. Now my question is under different business groups (different legislation) how employe information will be populated like Nationality etc ... ?
Business group ID: 80 Business group Name: Canada
Business group ID: 210 Business group Name: UK
Business group ID: 110 Business group Name: USA
Business group ID: 119 Business group Name: Dubai
In case of business group (DUBAI) tax is deducted from employee salary and Nationality is saved in Attribute 16 in PER_ALL_PEOPLE_F table in HRMS.
Assuming this is Oracle EBS source, nationality (from people table) is mapped to citizenship in W_HR_PERSON_LEG_D. For flexfield columns you will need to customize the source for this column in 184.108.40.206.1 however support for EBS flexfield configuration will hopefully come out in the next version.