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
Get Started: AI 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

edited May 19, 2020 8:24AM in Reporting and Analytics for HCM 2 comments

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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