HCM Extract | Excel Template | Parent child traversing in template

Summary:

Hi,

I am working on the HCM extract where excel template is being used.

The XML path looks like this:

Now, my requirement is to fetch attributes from different records.

For example - PERSON_NUMBER is under PERSON_REC

ASSIGNMENT_STATUS IS UNDER ASG_HIS_REC

PENSION_NUMBER IS UNDER PER_EXTRA_INFO_REC

I tried various approach but eventually extract is completing with error without generating any excel output.

Approach1: Set repeating group at PERSON_DG

And in excel meta deta sheet :

Person_Number logic: <?PERSON_REC/PERSON_NUM?>

Assignment_status logic : <?PERSON_REC/PERSON_NUM?><?ASG_HIS_DG_h/ASG_HIS_DG/ASG_HIS_REC/EMP_STATUS?>