SQL query to get the candidate's education details
I am facing an issue to get the candidate's education data using the SQL query:
FROM IRC_CAND_PROFILE_USAGES_M R,
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.