Get Started with Redwood for Oracle Cloud HCM Begin Now
How to generate report showing questionnaire of checklist
Summary:
I have attempted to generate a BI report displaying offboarding questionnaire responses labeled 'Interview.' However, my SQL query is producing duplicate data and some null rows that need to be removed in order to have a single line for each employee, any help
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
select
pact.CHECKLIST_NAME,
PATL.TASK_NAME,
hprv.QUESTIONNAIRE_ID,
papf.person_number employee_number,
ppnf.full_name Employee_Name,
MANAGER_NUMBER.managerno Manager_Number,
MANAGER_Name.managername,
Tagged:
0