Search Results default_posting_id




Overview
Explore in AI Chat

Overview

The IRC_DEFAULT_POSTINGS_TL table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the product family PER. As a translation table (indicated by the '_TL' suffix), its primary role is to store multilingual versions of default posting content. This table supports the global deployment of Oracle EBS by enabling the storage of translated text for default job postings, which are predefined templates or descriptions used within the iRecruitment functionality. It operates in conjunction with its base table, IRC_DEFAULT_POSTINGS_B, to provide a complete, language-aware data model for recruitment processes in versions 12.1.1 and 12.2.2.

Key Information Stored

The table stores translated textual attributes for a default posting record. Its structure is defined by a composite primary key consisting of DEFAULT_POSTING_ID and LANGUAGE. The DEFAULT_POSTING_ID column is a foreign key that links each translated row to its corresponding master record in the IRC_DEFAULT_POSTINGS_B table. The LANGUAGE column holds the language code (e.g., 'US', 'FR', 'DE') for the translation. While the exact column list is not detailed in the provided metadata, typical translation tables in Oracle EBS include columns such as POSTING_TITLE, DESCRIPTION, and possibly other narrative fields that require localization. A SOURCE_LANG column is also commonly present to denote the original language of the record.

Common Use Cases and Queries

The primary use case is to retrieve localized content for default job postings based on a user's session language setting within iRecruitment. This enables recruiters and candidates to view posting information in their preferred language. A common reporting need is to audit translation coverage—identifying which default postings have translations for specific target languages. Sample SQL patterns include fetching a translated posting for a given ID and language, or joining with the base table to get a complete view.

  • Retrieve Translation: SELECT posting_title, description FROM irc_default_postings_tl WHERE default_posting_id = 1000 AND language = USERENV('LANG');
  • Audit Translations: SELECT d.default_posting_id, COUNT(t.language) AS translation_count FROM irc_default_postings_b d LEFT JOIN irc_default_postings_tl t ON d.default_posting_id = t.default_posting_id GROUP BY d.default_posting_id;

Related Objects

The IRC_DEFAULT_POSTINGS_TL table has direct dependencies within the HR schema. Its most critical relationship is with its base table, IRC_DEFAULT_POSTINGS_B, which holds the non-translatable information for a default posting. The table is protected by the primary key constraint IRC_DEFAULT_POSTINGS_TL_PK. It is also likely referenced by public APIs or views within the iRecruitment product family that serve translated posting data to the application's user interface. While not specified in the metadata, related objects could include the IRC_POSTINGS table for actual job postings that may inherit from these defaults.