Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How to replace DATA_CACHE columns in 21B with XML_DATa_CACHE
Summary
How to replace DATA_CACHE columns in 21B with XML_DATa_CACHEContent
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
Tagged:
0