Get Started with Redwood for Oracle Cloud HCM Begin Now
Performance issues while using Period Name and Payroll Name in the Column Prompts LOV of a OTBI repo
Summary
Performance issues while using Period Name and Payroll Name in the Column Prompts LOV of a OTBI reportContent
Hi
I have 2 prompts on my OTBI report.
Period Name and Payroll Name.
Each is a column prompt and SQL Results dependent prompts.
SQL query for Period Name:
SELECT "Payroll Period"."Period Name"
FROM "Payroll - Payroll Run Results Real Time"
WHERE "Payroll Run Result Details"."Payroll Action Status Code" = 'C'
ORDER BY "Payroll - Payroll Run Results Real Time"."Payroll Period"."Default Pay Date" DESC
SQL query for Payroll Name:
SELECT "Payroll"."Payroll Period Name"
FROM "Payroll - Payroll Run Results Real Time"
0