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 document questionnaire with answers for worker and manager query

I am trying to build a query for Performance document questionnaire with answers for worker and manager query but its not giving correct answers.

When I add the tables for answers then row count increases.

Below is the query I am using.

Please suggest what join is missing.

SELECT DISTINCT papf.person_number Employee_ID
,ppnf.full_name Employee_Name

,paam.assignment_name
,ppos.date_start Start_Date
,papf1.person_number Manager_ID
,ppnf1.full_name Manager_Name,htpt.customary_name perf_doc_name

  --,he.evaluation_id       
,hes.section_type_code
,hsdv.name section_name
,he.status_code
,he.calibration_status

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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