HCM EXTRACT | EXCEL TEMPLATE | PARENT CHILD TRAVERSE LOOPING IN TEMPLATE

Summary:

Hi,

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

XML Structure:

My requirement is to fetch the attributes across the different records.

For example:

PERSON_ NUMBER is under PERSON_REC

EMPLOYEE_STATUS is under ASG_HIS_REC

PENSION_NUMBER is under PER_EXTRA_INFO_REC

Tried several approaches in excel template but eventually extract is completing with errors without generating the excel output file.

Approach1:

Set repeating node at PERSON_DG, in excel template→ under meta deta sheet →applied this logic in columns

PERSON_NUMBER = <?PERSON_REC/PERSON_NUM?>

EMPLOYEE_STATUS = <?ASG_HIS_DG_h/ASG_HIS_DG/ASG_HIS_REC/EMP_STATUS?>