Reporting on Transaction Actions and Reasons

Hello experts,

Im trying to build a report that can capture the Action and Action Reason from the transactions submitted by the HR team using the normal tables (hrc_txn_header,hrc_txn_data) and using join with the XML

LEFT JOIN XMLTABLE(
'/TRANSACTION/COMPAREDATA/CompareVO/AssignmentTerminationWhenAndWhyVORow/Compare[AttributeName="ActionId"]'
PASSING txnh.XML_DATA_CACHE
COLUMNS
AttributeName VARCHAR2(100) PATH 'AttributeName',
Newvalue VARCHAR2(50) PATH 'NewValue'
) xml_actionid ON 1=1

But the result its too slow and need to map to every action, can someone share some idea to get this information better?

regards