Search Results irc_default_postings




Overview
Explore in AI Chat

Overview

The IRC_DEFAULT_POSTINGS table is a core data repository within the Oracle E-Business Suite Human Resources (PER) module, specifically supporting the iRecruitment functionality. It serves as a centralized library or template system for job requisition postings. Its primary role is to store predefined posting configurations that can be mapped to a specific position, a job classification, or an organizational unit. This enables HR administrators to standardize and expedite the creation of new recruitment requisitions by leveraging pre-approved templates, ensuring consistency in job descriptions, requirements, and other posting attributes across the enterprise.

Key Information Stored

The table's structure is designed to link a posting template to a single primary entity within the HRMS structure. The most critical columns include the unique identifier, DEFAULT_POSTING_ID, which serves as the primary key. The mapping is established through foreign key columns: JOB_ID, which references the PER_JOBS table to associate the template with a specific job; ORGANIZATION_ID, which references HR_ALL_ORGANIZATION_UNITS to associate it with a specific department or business group; and a POSITION_ID (implied by the description, though not explicitly listed in the provided foreign keys) for position-based templates. Each record represents a distinct template containing the full complement of data necessary to generate a complete job posting.

Common Use Cases and Queries

A primary use case is the rapid generation of a new job requisition. When a recruiter initiates a req for a specific job in a department, the application can query this table to suggest or automatically apply a matching default posting template. Common reporting and administrative queries include listing all available templates or identifying gaps in coverage. A sample SQL pattern to retrieve all templates for a specific job family would involve joining with PER_JOBS.

SELECT idp.default_posting_id, idp.name, pj.job_name
FROM irc_default_postings idp
JOIN per_jobs pj ON idp.job_id = pj.job_id
WHERE pj.job_function = 'IT'
AND idp.organization_id IS NULL;

This query finds IT job templates not restricted to a single organization.

Related Objects

The IRC_DEFAULT_POSTINGS table is integral to the iRecruitment data model, with defined relationships to fundamental HRMS tables. As per the documented foreign keys:

  • PER_JOBS: Joined via the JOB_ID column. This links a posting template to a defined job, such as "Senior Accountant."
  • HR_ALL_ORGANIZATION_UNITS: Joined via the ORGANIZATION_ID column. This links a template to a specific organizational unit, allowing for department-specific posting variants.

The table is also referenced by other iRecruitment objects (like IRC_POSTINGS_ALL, which likely holds instances of actual live postings created from these defaults) and is accessed through standard Oracle HRMS APIs for data integrity and security.