per_pos_tree_node_rf and PER_POS_TREE_NODE_RF tables empty, though it is visible from frontend

Summary:

I am developing an HCM Extract to send Position Structure data external source. One of the required fields is the Parent Position Code for each position.

When navigating to:

My Client Groups → Workforce Structures → Manage Positions

We can clearly see the Parent Position field populated for positions in our instance.It is visible form the frontend.

We attempted to use the standard Oracle HCM Extract UE which internally uses :

PER_EXT_POSITION_TREE_UE, it uses this table in UE query per_pos_tree_node_rf

SELECT hapv.name, hapv.position_id,
pgtn_rf.distance, pk1_value,
tree_version_id, tree_code, tree_structure_code