Results for “irc_default_postings_vl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view APPS.IRC_DEFAULT_POSTINGS_VL belongs to the PER (Human Resources) product family within Oracle E-Business Suite and is documented for releases 12.1.1 and 12.2.2. It is a VALID database object owned by the APPS schema and functions as the MLS (Multi-Language Support) "_VL" view for the iRecruitment default postings entity. In an MLS design, a "_VL" view joins a base (non-translated) table to its corresponding "_TL" translation table and restricts the translation rows to the session language returned by USERENV('LANG'). This view therefore presents one logical row per default posting, resolved to a single language.

The view exposes both transactional/descriptive attributes from the base table and the language-dependent posting text (job title, brief, detailed, and requirements). Because it is a view and not a table, it is read-only for reporting purposes and is intended for querying, reporting, and integration rather than direct DML. It is the appropriate source whenever a query must return the default posting content in the language of the current user session, including the user's search term org_description.

Underlying Base Objects

The documented metadata lists two referenced base objects, both accessed as synonyms: IRC_DEFAULT_POSTINGS (the base/non-translated table, aliased IDP) and IRC_DEFAULT_POSTINGS_TL (the translated table, aliased IDT). The view text shows the join condition IDP.DEFAULT_POSTING_ID = IDT.DEFAULT_POSTING_ID combined with the language filter IDT.LANGUAGE = USERENV('LANG'). Column-level ownership follows this split: identifiers and flexfield attributes (DEFAULT_POSTING_ID, POSITION_ID, JOB_ID, ORGANIZATION_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1–30, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER, ROWID) are drawn from the base table, whereas ORG_DESCRIPTION and the other descriptive text fields (ORG_NAME, JOB_TITLE, BRIEF_DESCRIPTION, DETAILED_DESCRIPTION, JOB_REQUIREMENTS, ADDITIONAL_DETAILS, HOW_TO_APPLY, IMAGE_URL, IMAGE_URL_ALT) are drawn from the translated table. Note that only the translation table carries the language-dependent values, so the language filter on the TL side drives the visible result set.

Key Columns

• DEFAULT_POSTING_ID — Primary key linking the base and translated rows; the join driver of the view.
• ORG_DESCRIPTION — Organization description sourced from IRC_DEFAULT_POSTINGS_TL; the object of the user's search and a language-sensitive attribute.
• ORG_NAME — Organization display name, also from the TL table.
• POSITION_ID, JOB_ID, ORGANIZATION_ID — Foreign keys to position, job, and organization entities used for filtering and joins to HR master data.
• JOB_TITLE, BRIEF_DESCRIPTION, DETAILED_DESCRIPTION, JOB_REQUIREMENTS, ADDITIONAL_DETAILS, HOW_TO_APPLY — Posting narrative content in the session language.
• IMAGE_URL, IMAGE_URL_ALT — Optional image references for the posting.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30 — DFF (Descriptive Flexfield) context and segment values from the base table.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER — Standard WHO/audit and OVN columns.

Common Use Cases and Queries

Typical uses include iRecruitment posting reporting, extracting posting text for external job boards or integrations, and building custom dashboards in BI Publisher, OBIEE, or APEX. Because the view resolves language automatically via USERENV('LANG'), a report will return the text in the language of the session that executes it. A representative query for the user's org_description search is:

• SELECT default_posting_id, organization_id, org_name, org_description FROM apps.irc_default_postings_vl WHERE org_description IS NOT NULL;
• SELECT default_posting_id, org_name, job_title FROM apps.irc_default_postings_vl WHERE job_id = :job_id;
• SELECT organization_id, COUNT(*) FROM apps.irc_default_postings_vl GROUP BY organization_id;

When developing against this view, bear in mind that the language filter is implicit; to retrieve a specific language other than the session default, either set the session language or query IRC_DEFAULT_POSTINGS_TL directly with an explicit LANGUAGE predicate.