Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCM
Summary:
Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCM for fetching employee division.
Content (please ensure you mask any confidential information):
Hi ,
Please help us to find the Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCM for fetching employee division. This table HR_ORGANIZATION_UNITS_F_TL contains division name but when joined with location id multiple data got fetched. Please help to identify another join to fetch division of an employee.
Regards,
Hitha
Version (include the version you are using, if applicable):