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

1. candidate applies from career site and provide the education detail.
2. 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.