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 with Redwood for Oracle Cloud HCM   Begin Now

Query to get Score Given By Line Manager for the Assigned Checklist that is Attached to Offering

Summary:

Hi Team,

We are trying to get the score from a Checklist assigned to the employee for a particular offering.
Below is the query we have used by passing the learning_item_id and Participant_id(Manager_id) and Question is hardcoded

We are getting 3 rows for the specific combination. Can anyone please help me as we are getting unique 3 subject_id for this scenario and we are not able to get the correct join of subject_id in HRQ_QSTNR_PCPT_RESPONSES_V view.

Please somebody guide us with the correct join of these tables from Application we can see for attached Learning Item id we are getting 20 Score

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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