Search Results irc_skills_matching_pkg




Overview
Explore in AI Chat

Overview

The APPS.IRC_SKILLS_MATCHING_PKG package is a PL/SQL API that provides the core skills-matching engine for Oracle EBS iRecruitment and Oracle Talent Acquisition functionality. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, the package computes how closely an individual (applicant, employee, or candidate) matches a defined set of required and preferred skills at specified proficiency levels.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the defining schema. Its principal business purpose is to return a percentage value that expresses the degree to which a person's competences satisfy a target skill profile. Where essential skills are not satisfied, the API returns a sentinel value of -1, signalling outright disqualification regardless of preferred-skill matching. This behaviour underpins screening, ranking, and short-listing logic in recruitment workflows.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions within the package:

  • SKILLS_MATCH — The principal function for computing the percentage match between a person and a list of skills. It accepts comma-delimited strings of essential skills, essential minimum levels, essential maximum levels, preferred skills, preferred minimum levels, and preferred maximum levels, together with a person identifier and a Boolean percent flag. When the percent flag is true, a full percentage is returned; when false, processing halts as soon as the pass/fail outcome is determinable. If any essential skill is unmatched, a '-1' is returned. Inputs of inconsistent length raise an error.
  • SKILLS_MATCH_PERCENT — A wrapper function exposing the percentage-returning behaviour of the matching logic. It is intended to be called directly by consumers that require only the computed match value.
  • SKILLS_MATCH_TEST — A test and diagnostic entry point used to exercise the matching logic, aiding developers validating skill-match scenarios during implementation and support.
  • VACANCY_MATCH_PERCENT — Returns a percentage indicating how well a candidate matches a vacancy's defined skill requirements, supporting vacancy-level ranking and eligibility decisions.
  • GET_SKILLS_FOR_SCOPE — Retrieves the set of skills associated with a given scope, supplying the skill lists consumed by the matching functions.
  • GET_SKILLS_FOR_VAC — Retrieves the skills associated with a specific vacancy, enabling vacancy-oriented matching and display.

Tables Accessed

The package references the following tables through APPS synonyms:

  • PER_ALL_VACANCIES — The vacancy definition table, used to resolve vacancy-level skill requirements for vacancy matching.
  • PER_COMPETENCES — Stores competence definitions, providing the skill/competence catalogue against which matching occurs.
  • PER_COMPETENCE_ELEMENTS — Holds the individual elements that constitute competences, supporting the granular skill comparison.
  • PER_RATING_LEVELS — Supplies the proficiency rating scale used to compare a person's skill level against the required minimum or maximum levels.
  • PLITBLM — A PL/SQL index-by table structure used internally to parse and hold the comma-delimited skill and level strings passed into the matching functions.

Usage Notes

IRC_SKILLS_MATCHING_PKG is primarily invoked by iRecruitment forms and concurrent programs that present or rank candidates against vacancy and scope skill profiles. It is called when an applicant submits an application, when recruiters view candidate match percentages, and when vacancy short-listing or screening logic evaluates essential versus preferred skill criteria.

Because the package is documented as API classification OTHER and is referenced by no other packages, it forms a leaf-level dependency in the iRecruitment call stack, generally invoked directly from form logic or custom extensions rather than through a broader API hierarchy. Developers extending skill-matching behaviour should note the essential-skill disqualification rule (-1) and the recommendation to add restrictive WHERE clauses to views so that parties returning -1 are excluded from result sets. The SKILLS_MATCH_TEST function assists in validating custom skill configurations before production use.