Is there any way to get transaction old and new value list for transactions?
Summary:
Is there any way to get transaction old and new value list for transactions?
Content (required):
Hi Team,
Greetings!
Is there any way to get transaction old and new value list for transactions?
e.g.
If there is a promotion transaction-
that will include the details in terms of old and new values for the changed fields.
But, the data from HRC_TXN_DATA/ HRC_TXN_HEADER is not something one can easily decipher to get the changed fields.
Example below-
select h.xml_data_cache.getClobVal() from fusion.hrc_txn_header h where transaction_id = 11111111
gives the entire XML but it still needs a lot of manual drill-down to get the exact changes.
Tagged:
0