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.
XML data need to display data in separate fields
Content
Hi All,
We have a requirement when we perform any Job change action from Fusion Cloud HRMS application it will go for approval. In this stage we need to build a BIP report to display data like who initiated the process and who are going to approve this transaction.
I did research on this and I found that data will be there in “DATA_CACHE” column in “hrc_txn_data” table but here the data will be stored in a XML format.
I need your help to display data in a separate fields.
Please suggest.
Thanks,
Visu
0