You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

In Compensation, for approval. Need to extract Applied data from hrc_txn_head

in Reporting and Analytics for HCM 2 comments

After applying individual compensation, it went for approval. Applied data is stored in hrc_txn_header. We are not able to extract ElementTypeId, ElementEntryId, InputValueId & ScreenEntryValue from hrc_txn_header table…..

Below is the query for the Reference …..

SELECT
extractvalue(xml_data_cache, '/TRANSACTION/TransCtx/DisplayName') DisplayName
, extractvalue(xml_data_cache, '//EO/ElementEntryValueDEORow/ElementTypeId') ElementTypeId
, extractvalue(xml_data_cache, '/EO/ElementEntryValueDEORow/ElementEntryId') ElementEntryId
, extractvalue(xml_data_cache, '/TRANSACTION/BUSINESSDATA/AM/cd/TXN/EO/ElementEntryValueDEORow/InputValueId') InputValueId
, extractvalue(xml_data_cache, '/TRANSACTION/BUSINESSDATA/AM/cd/TXN/EO/ElementEntryValueDEORow/ScreenEntryValue') ScreenEntryValue

FROM
hrc_txn_header

WHERE
transaction_id = 300000624785829

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!