I need to create HCM Extract bringing Organization Tree showing Org hierarchy for the organization associated with an employee. I ran the Row flattening process on the Org tree
Join PER_EXT_SEC_ASSIGNMENT_UE.PER_EXT_ASG_ORG_ID
to
PER_EXT_ORGANIZATION_TREE_UE.PER_EXT_ORG_TREE_PK1_VALUE
Also put filter condition on
PER_EXT_ORG_TREE_VERSION_NAME = {Version}
PER_EXT_ORG_TREE_DISTANCE > 0
However its not working. I need some help. Pls. advise.
Thanks,
Aamir