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

How to replace DATA_CACHE columns in 21B with XML_DATa_CACHE

Received Response
11
Views
4
Comments
edited Aug 23, 2021 4:59PM in Reporting and Analytics for HCM 4 comments

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
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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