Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

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!