Performance issue while fetching details from data_cache column

Summary

I am facing performance issue while fetching details from data_cache column.

Content

Hi Team,

I am using below query for fetching all kind of approval transactions. Although query worked fine but it is taking long time to fetch the details. Could someone please have a look and let me know any better way to achieve this?

 

With Transaction_Info As 

(select --a.Salary_New , 

--b.Salary_Prior,

papf.person_number,

ppnf.display_name Employee_Name,

--c.AdjustmentPercentage,

--d.AdjustmentAmount,

E.manager_new,

F.Teleworker_New,

(SELECT NAME FROM HR_ORGANIZATION_V 

WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE