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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
SQL query to get the candidate's education details
Summary:
Hi All,
I am facing an issue to get the candidate's education data using the SQL query:
SELECT U.*
FROM IRC_CAND_PROFILE_USAGES_M R,
IRC_PROFILE_EDUCATION_ITEMS_V U
WHERE R.PROFILE_ID (+)= U.PROFILE_ID
AND R.PROFILE_TYPE (+)='ORA_CANDIDATE_PROFILE'
AND R.PERSON_ID = 300003920830965
Query gives the results perfectly whenever
- candidate applies from career site and provide the education detail.
- Recruiter creates the candidate profile and provide the education details immediately while creating the profile.
I am facing the issue in a scenario where the candidate profile is created in the past without education details and now recruiter is adding the Degree information. In that case table "IRC_CAND_PROFILE_USAGES_M" is not getting updated with the latest profile_ID.
Tagged:
0