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

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