Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extracting data from xml in SQL query

Thiago RamosMar 2 2022

hi
I'm putting together a report that takes all the information from all transactions made in HCM. I'm using the fusion.hrc_txn_header Table and getting the xml_data_cache column that brings all the transaction into an XML.
Some more information is in an Array in XML that brings the previous value and the new value example <Compare>
<AttributeName>FrequencyValue</AttributeName>
<Label>Frequency</Label>
<ResourceBundle>oracle.apps.hcm.employment.resource.HcmEmploymentTopAttrBundle</ResourceBundle>
<ResourceKey>ColAttr.Frequency.WorkingHoursFrequency.BaseWorkerAssignmentVO.FrequencyValue</ResourceKey>
<OldId/>
<NewId/>
<OldValue>Monthly</OldValue>
<NewValue>Monthly</NewValue>
</Compare>

I wanted to know how I can get the previous value and new value

Added on Mar 2 2022

#cloud-applications, #hcm, #hcm-cloud-service, #transaction

2 comments

1,560 views