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