How does the system handle duplicate candidates in Oracle?

When a resume is parsed and sent to Oracle, the system ensures that duplicate candidates are not created by following a structured validation process.

Initial Step

The parsed candidate data is sent to Oracle. Oracle will either:

• Create the candidate successfully, or
• Return a duplicate error if a candidate with the same email address already exists

Duplicate Handling Process

If a duplicate error occurs, the system performs the following steps:

1. Search by Last Name and Full Name
   Since Oracle does not support direct search by email, the system performs:
   • A search using the candidate’s last name, and
   • A search using the candidate’s full name (first + last name)
2. Retrieve Candidate List
   Oracle returns a list of candidates matching the search criteria.
3. Email Comparison
   The system iterates through the returned records and compares each record’s email address with the parsed resume’s email.

Outcome

• If a matching email is found
  → The existing candidate record is updated
• If no matching email is found
  → The system logs an error for further investigation and does not update any record

Example

A resume is parsed with:

• Name: John Smith
• Email: john.smith@email.com

Step 1: Candidate is sent to Oracle
→ Oracle returns a duplicate error (email already exists)

Step 2: System searches:

• By last name: Smith
• By full name: John Smith

Step 3: Oracle returns results such as:

• John Smith – john.smith@email.com
• Jane Smith – jane.smith@email.com
• John Smith – johnny.smith@email.com

Step 4: Email comparison is performed
→ Match found: john.smith@email.com

Result:
The existing John Smith record is updated.

Edge Case

If no email match is found in the returned records:

• The system does not update any candidate
• An error is logged for manual investigation to prevent incorrect data updates

For more information, contact RChilli Support