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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

XML data need to display data in separate fields

edited Jul 20, 2016 6:44AM in Reporting and Analytics for HCM 2 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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