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
Skip to content
  • Register
    • Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

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

    How to replace DATA_CACHE with XML_DATA_CACHE syntax in Oracle BIP Data Models?

    edited Mar 17, 2021 11:48AM in Reporting and Analytics for HCM 4 comments

    Summary

    How to replace DATA_CACHE with XML_DATA_CACHE syntax in Oracle BIP Data Models?

    Content

    Hi Experts,

    We came to know that Oracle deprecated 'DATA_CACHE' column and replaced with 'XML_DATA_CACHE'.

    We are trying to replace syntax for the below code snippet. This is not working. 

    XMLTABLE('$A/root/TRANSACTION/TransCtx/CmpTxnNewSalaryValuesMap' PASSING xmltype('<root>'||htd.data_cache||'</root>') AS A 
      columns 

    If someone worked on similar requirement, could you please let me know how to rewrite this syntax to get data from 'XML_DATA_CACHE'.

    Thanks in Advance!

    Thanks,

    Harish

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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