Candidate Submission Source is Missing

Hi,

You might notice that some candidate applications have no Source information in Oracle Recruiting (our current version is 24B).

You can get a list of impacted submissions by running the following query in a BIP data model:

SELECT
c.candidate_number,
r.requisition_number,
pvl.name csp_phase,
svl.name csp_state,
to_char(s.submission_date, 'YYYY-MON') SUBMITTED_MONTH
from
irc_candidates c,
irc_submissions s,
irc_requisitions_b r,
irc_phases_vl pvl,
irc_states_vl svl,
irc_source_tracking src
where 1=1
and c.person_id = s.person_id
and s.requisition_id = r.requisition_id
and s.submission_id = src.submission_id (+)