New DG SBU (Organization_id) join to per_jobs_f - what are the join elements in HCM

Summary

Need to create new extract cannot find suitable UE for Organization and Job tables (Mulit-Countries)

Content

Hello:

I need to create new "job file" outbound extract cannot find suitable UE joining  Organization and Job tables (Mulit-Countries)

Original UE was PER_EXT_SEC_JOB_UE, but does not allow us to see job codes that are in multiple countries

Having trouble linking HR_ALL_ORGANIZATION_UNITS_F hao,
           HR_ORGANIZATION_UNITS_F_TL haot,
           per_jobs_f_vl job 

 

And we are not using Positions.   Appreciate any feedback and/or advice

Thank you,

John White

Version

Oracle Cloud Application 20A (11.13.20.01.0)