How to replace DATA_CACHE columns in 21B with XML_DATa_CACHE

Summary

How to replace DATA_CACHE columns in 21B with XML_DATa_CACHE

Content

Hello,

Can anyone help me replace DATA_CACHE columns in 21B with XML_DATa_CACHE, in BI reports? I am doing this the rfirst time, and I will really appreciateo fsomeone can share some sample code here. Thanks a lot.

Pls see below a sample code which I should replace 

 

SELECT  rownum

,WFT.ASSIGNEESDISPLAYNAME NEXT_APPROVER 

,WFT.FROMUSERDISPLAYNAME CURRENT_APPROVER1

,DP.PERSON_NUMBER PERSON_NUMBER

,TXND.STATUS STATE1

,WFT.OUTCOME OUTCOME1

-- ,TXNH.OBJECT_ID ASSIGNMENT_ID

-- ,DP.MAILING_ADDRESS_ID MAILING_ADDRESS_ID

,TO_DATE(EXTRACTVALUE(XMLTYPE.CREATEXML(DATA_CACHE), '/TRANSACTION/BUSINESSDATA/AM/TXN/EO/PeriodOfServiceEORow/ActualTerminationDate/DATA'),'RRRR-MM-DD') ATD