Search Results offer_version

Overview

The IRC_OFFERS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Human Resources (HR) module. It serves as the primary repository for storing and managing all details related to job offers generated through the iRecruitment module. This table is fundamental to the recruitment workflow, enabling organizations to create, track, revise, and maintain the history of offers extended to candidates. Its role is to centralize offer data, linking it to specific vacancies, applicant assignments, and individuals, thereby supporting the entire offer lifecycle from generation through acceptance or rejection.

Key Information Stored

The table's structure is designed to capture comprehensive offer details. Its primary key is the OFFER_ID, which uniquely identifies each offer record. A significant business key is the combination of APPLICANT_ASSIGNMENT_ID and OFFER_VERSION, which allows the system to maintain a history of different versions of an offer for the same candidate assignment. Key foreign key columns establish critical relationships: VACANCY_ID links the offer to a specific job opening in PER_ALL_VACANCIES, APPLICANT_ASSIGNMENT_ID connects it to the candidate's application, and ADDRESS_ID may store location details from PER_ADDRESSES. Additional important columns include RESPONDENT_ID (linking to the FND_USER table to identify the person responding to the offer) and TEMPLATE_ID (referencing XDO_TEMPLATES_B for the offer letter template used).

Common Use Cases and Queries

This table is central to several operational and reporting scenarios in iRecruitment. Common use cases include generating a list of all active offers for a recruiter, tracking the status history of a specific offer, and auditing offer versions for a particular candidate. A typical reporting query might join IRC_OFFERS with PER_ALL_VACANCIES and candidate personal information to analyze offer trends by department or job. For workflow support, applications frequently query the table to determine the current version of an offer or to retrieve template and address details for generating an offer letter. Sample SQL often involves filtering by VACANCY_ID, APPLICANT_ASSIGNMENT_ID, or by joining with the IRC_OFFER_STATUS_HISTORY table to get the latest status.

Related Objects

The IRC_OFFERS table is a hub within the iRecruitment schema, with several key dependencies. It is directly referenced by the IRC_OFFER_STATUS_HISTORY table, which tracks status changes over an offer's lifecycle via the OFFER_ID foreign key. Major foreign key relationships, as documented, link it to: PER_ALL_VACANCIES for vacancy details, PER_ADDRESSES for location data, FND_USER for user information, and XDO_TEMPLATES_B for document templates. The table is also intrinsically linked to applicant data through the APPLICANT_ASSIGNMENT_ID, which would typically relate to the IRC_APPLICANT_ASSIGNMENTS entity. Any custom reports or integrations involving offer data will primarily source from this table.