There seem to be a number of Oracle tools that can be used generate XML files.

Does anyone have any experience or advice on what tool may be best to generate a complex, large XML data extract file from HR to a external 3rd party system on a daily basis?

Can an .xsd file be used as a template for the output rather than having to manually define all the tags?

This is on 11.5.9 FP E.

Any advice or info would be greatly appreciated.

My only experience of this was building an output 'report' from an e-Recruitment interface.
The output xml is sent back to the source to give them a heads-up as to what records loaded and what recs failed (and why).
We ended-up creating the tags on the fly as the output was too variable to contain with an xsd.
AS for the tool, I used trusty pl/sql and fnd_file. Not rocket science!

Not had a chance to play with xml publisher yet.