Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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