How to return specific Child in for each loop?
currently I am working with the Sales Order Report RTF templates and XML data model. I am working in Oracle Fusion ERP in the SCM catalog within OTBI. specifically testing and building in the following folder structure:
/shared/Custom/Supply Chain Management/Order Management/Sales Orders
Goal: Get correct child value (PercentOfComparisonElement) in a for each function on Line level
Question: How can I make sure to return the second child for all the lines?
Data model is constructed as follows: //Header/Line/Charges/Chrage/ChargeComponents/ChargeComponent
Now I want for example to have all the data in the example on Line level in a table