On this post will see a way for creating XSLT maps that need to loop thought different sources (aka input payloads) which their instances are correlated by key fields.
I will use the Business units and Employees classic example: Each Business Unit can have 0..n Employees (1:0..n relationship). Also the G/L Accounts source with a 1:1 correlation with Business Units. I want to create a XSLT Map that puts them together. Here are the sources (aka input payloads). Read the complete article here.
For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.