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

How to extract Prescreen Question and Responses filled by candidate in BIP Report?

in Recruiting, Opportunity Marketplace 3 comments

Summary: I have tried the following by joining the relevant tables as suggested by

Oracle Fusion Recruiting Cloud: OTBI/BIP: How to Report on Candidate Question Responses (Doc ID 2603859.1)

The data is visible in the front end however, when I execute the query it shows no data.


Content (please ensure you mask any confidential information):

Select ANS.* from

IRC_CANDIDATES IC,IRC_SUBMISSIONS IRS,IRC_SUBMISSIONS IRSUB,HRQ_QSTNR_PARTICIPANTS HRP,HRQ_QSTNR_PCPT_RESPONSES_V HRPQ,HRQ_QUESTIONS_VL HRQVL,HRQ_ALL_QSTN_RESPONSES_V ANS

Where IC.person_id = IRS.person_idand IRS.SUB_ID_CHAR = HRP.SUBJECT_IDand HRP.PARTICIPANT_ID = HRPQ.PARTICIPANT_IDand HRPQ.QUESTION_CODE = HRQVL.QUESTION_CODEand HRPQ.QSTN_RESPONSE_ID = ANS.QSTN_RESPONSE_ID--and IC.person_id = '300000332894457'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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