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

    SQL Query to fetch interview feedback question and answer

    in Recruiting, Opportunity Marketplace 1 comment

    Summary:

    Hi Team,I want to create a report where that will fetch interview feedback questions and answers.

    I have created the custom query but it's not giving the expected result, please help me with the tables and mapping. Please take a look at the query.

    select distinct
    ic.candidate_number,
    ppnfv.full_name,
    irv.requisition_number,
    TO_CHAR(IIFR.EXPIRY_DATE,'DD/MM/YYYY')FEEDBACK_EXPIRY_DATE,
    TO_CHAR(IIFR.COMPLETION_DATE,'DD/MM/YYYY')FEEDBACK_COMPLETION_DATE,
    IIFR.RATING,
    papf1.PERSON_NUMBER Respondent_EMP_NUMBER,
    ppnfv1.DISPLAY_NAME Respondent_EMP_NAME,
    IIFRD.FEEDBK_RESP_DETAILS_ID,
    IIFRD.FEEDBACK_ID,

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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