Setting up the Questioners in Oracle Performance Management
Dear Sir,We need to know how to link the Questioners with Appraisal table
The problem is that I made a query, but I am not obtaining results because there's no relation between PER_APPRAISALS.APPRAISAL_ID column and HR_QUEST_ANSWERS.TYPE_OBJECT_ID column. The value of HR_QUEST_ANSWERS.TYPE_OBJECT_ID does not correspond to anything in PER_APPRAISALS table, even we find a note ID (73471.1) select statement using this relation:
select papf.Full_name,pat.name,hq.name,hqa.questionnaire_answer_id,
hqa.questionnaire_template_id, hqa.type, hqa.type_object_id,
hqa.business_group_id, hqav.value
The problem is that I made a query, but I am not obtaining results because there's no relation between PER_APPRAISALS.APPRAISAL_ID column and HR_QUEST_ANSWERS.TYPE_OBJECT_ID column. The value of HR_QUEST_ANSWERS.TYPE_OBJECT_ID does not correspond to anything in PER_APPRAISALS table, even we find a note ID (73471.1) select statement using this relation:
select papf.Full_name,pat.name,hq.name,hqa.questionnaire_answer_id,
hqa.questionnaire_template_id, hqa.type, hqa.type_object_id,
hqa.business_group_id, hqav.value
0