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

Report to extract Assessment Questionnaire of Learning section

edited Mar 31, 2021 9:28AM in Reporting and Analytics for HCM 3 comments

Summary

Need to extract assessment questionnaire of an offering linked to a learner

Content

Hi All,
I am trying to extract the assessment questionnaire with the answers inserted in the offer.
The query I am using is the following

select 
part.*,
quest.name

from HRQ_QUESTIONNAIRES_VL quest
join HRQ_QSTNR_PARTICIPANTS part on part.questionnaire_id=quest.questionnaire_id
 join WLF_ASSIGNMENT_RECORDS_F **** on to_char(****.assignment_record_id)=part.subject_id

whre part.SUBSCRIBER_ID='10'

 but I cannot find any results.
Do you have any suggestions?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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