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
Skip to content
  • 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

    edited Aug 8, 2024 1:25PM in Reporting and Analytics for HCM

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

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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