I'm working with an Oracle BI Publisher RTF template, and I am trying to create a table where the Extract_Person_Number is displayed in the first column, and for each person, their previous employment details (Employer Name and Employment End Date) should appear in subsequent rows. The issue is that when I try to display multiple rows for each person (with the previous employment details), the Extract_Person_Number doesn't show up, even though it should only appear once in the first row.
The XML output that we are using in the RTF template is :
<DATA_DS>
<G_1>
<PAYROLL_ACTION_ID>28</PAYROLL_ACTION_ID>
<G_2>
<FILE_FRAGMENT>
<XX_Psft_Intg_POC_2>
<REP_CATEGORY_NAME>XX Psft Intg POC 2</REP_CATEGORY_NAME>
<parameters>
<request_id>300000004769531</request_id>
<FLOW_NAME>sk 4</FLOW_NAME>
<legislative_data_group_id/>
<effective_date>2025-03-04</effective_date>
<start_date/>
<report_category_id>300000004769405</report_category_id>
<action_parameter_group_id/>
</parameters>
<Person>
<Person>
<Extract_Person_ID>10002984082</Extract_Person_ID>
<Extract_Person_Effective_Start_Date>2024-10-22T00:00:00.000Z</Extract_Person_Effective_Start_Date>
<Extract_Person_Number>81</Extract_Person_Number>
<Extract_Person_Primary_EMail_ID>10002984085</Extract_Person_Primary_EMail_ID>
<Extract_Person_System_Person_Type>PWK</Extract_Person_System_Person_Type>
<Person_Full_Name>Last407, First407</Person_Full_Name>
<PrevExp>
<PrevExp>
<Extract_Previous_Employment_Employer_Name>Prev Empl Emplr Name 1</Extract_Previous_Employment_Employer_Name>
<Extract_Previous_Employment_End_Date>2024-10-27T00:00:00.000Z</Extract_Previous_Employment_End_Date>
<Extract_Previous_Employment_Name>Prev Empl Name 1</Extract_Previous_Employment_Name>
<Extract_Previous_Employment_Person_Id/>
</PrevExp>
</PrevExp>
<PrevExp>
<PrevExp>
<Extract_Previous_Employment_Employer_Name>Prev Empl Emplr Name 2</Extract_Previous_Employment_Employer_Name>
<Extract_Previous_Employment_End_Date>2029-10-27T00:00:00.000Z</Extract_Previous_Employment_End_Date>
<Extract_Previous_Employment_Name>Prev Empl Name 2</Extract_Previous_Employment_Name>
<Extract_Previous_Employment_Person_Id/>
</PrevExp>
</PrevExp>
</Person>
</Person>
<Person>
<Person>
<Extract_Person_ID>10002588238</Extract_Person_ID>
<Extract_Person_Effective_Start_Date>2024-09-11T00:00:00.000Z</Extract_Person_Effective_Start_Date>
<Extract_Person_Number>78</Extract_Person_Number>
<Extract_Person_Primary_EMail_ID>10002588241</Extract_Person_Primary_EMail_ID>
<Extract_Person_System_Person_Type>PWK</Extract_Person_System_Person_Type>
<Person_Full_Name>Thumb, Tom</Person_Full_Name>
<PrevExp>
<PrevExp>
<Extract_Previous_Employment_Employer_Name>1 name only</Extract_Previous_Employment_Employer_Name>
<Extract_Previous_Employment_End_Date>2024-10-20T00:00:00.000Z</Extract_Previous_Employment_End_Date>
<Extract_Previous_Employment_Name/>
<Extract_Previous_Employment_Person_Id/>
</PrevExp>
</PrevExp>
</Person>
</Person>
<Person>
<Person>
<Extract_Person_ID>10002930812</Extract_Person_ID>
<Extract_Person_Effective_Start_Date>2024-10-20T00:00:00.000Z</Extract_Person_Effective_Start_Date>
<Extract_Person_Number>51</Extract_Person_Number>
<Extract_Person_Primary_EMail_ID>10002930815</Extract_Person_Primary_EMail_ID>
<Extract_Person_System_Person_Type>PWK</Extract_Person_System_Person_Type>
<Person_Full_Name>Last402, Last402</Person_Full_Name>
<PrevExp>
<PrevExp>
<Extract_Previous_Employment_Employer_Name/>
<Extract_Previous_Employment_End_Date/>
<Extract_Previous_Employment_Name/>
<Extract_Previous_Employment_Person_Id/>
</PrevExp>
</PrevExp>
<PrevExp>
<PrevExp>
<Extract_Previous_Employment_Employer_Name/>
<Extract_Previous_Employment_End_Date/>
<Extract_Previous_Employment_Name/>
<Extract_Previous_Employment_Person_Id/>
</PrevExp>
</PrevExp>
</Person>
</Person>
</XX_Psft_Intg_POC_2>
</FILE_FRAGMENT>
</G_2>
</G_1>
</DATA_DS>
Expected Output:
Person Number | Previous Employment Employer Name | Extract Previous Employment End Date |
---|---|---|
81 | Prev Empl Emplr Name 1 | 2024-10-27T00:00:00.000Z |
Prev Empl Emplr Name 2 | 2029-10-27T00:00:00.000Z | |
78 | 1 name only | 2024-10-20T00:00:00.000Z |