Results for “irc_posting_contents_vl”

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

Overview

IRC_POSTING_CONTENTS_VL is a multilingual (VL) view owned by the APPS schema in Oracle E-Business Suite, registered under the PER — Human Resources product family. It exposes the descriptive and administrative content associated with recruitment posting records held in the iRecruitment module (IRC). The view consolidates the language-independent attributes of a posting content record with its translated, user-facing text, resolving the translated columns to the session language through the USERENV('LANG') predicate.

In EBS 12.1.1 and 12.2.2, the object carries a status of VALID and is classified as a VIEW. Its role in reporting and integration is to provide a single, flat, language-aware projection of posting content — organization name, job title, brief and detailed descriptions, job requirements, benefits, how-to-apply instructions, image references, and the descriptive flexfield attribute and IPC information columns. Because it presents translated content automatically for the current runtime language, it is the preferred source for iRecruitment posting extracts, custom reports, and interfaces that must render posting text correctly for a given user locale, rather than querying the underlying _TL table directly.

Underlying Base Objects

The view is defined over two synonyms that resolve to the iRecruitment posting content tables:

• IRC_POSTING_CONTENTS (SYNONYM) — the base, language-independent table, aliased IPC in the view text, holding POSTING_CONTENT_ID, the DISPLAY_MANAGER_INFO and DISPLAY_RECRUITER_INFO flags, the ATTRIBUTE1–30 descriptive flexfield columns, the IPC_INFORMATION1–30 columns, WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), and OBJECT_VERSION_NUMBER.
• IRC_POSTING_CONTENTS_TL (SYNONYM) — the translation table, aliased IPT, supplying the language-specific NAME, ORG_NAME, ORG_DESCRIPTION, JOB_TITLE, BRIEF_DESCRIPTION, DETAILED_DESCRIPTION, JOB_REQUIREMENTS, ADDITIONAL_DETAILS, HOW_TO_APPLY, IMAGE_URL, IMAGE_URL_ALT, and BENEFIT_INFO columns.

The two are joined on POSTING_CONTENT_ID, with the additional filter IPT.LANGUAGE = USERENV('LANG') restricting the result to the session language. The view exposes IPC.ROWID as ROW_ID, but since it is a join of two tables, it is not inherently updatable as a key-preserved single-table entity.

Key Columns

• ROW_ID — the rowid of the base IRC_POSTING_CONTENTS row, usable as a pseudo key.
• POSTING_CONTENT_ID — the primary identifier linking the content record to a posting.
• NAME, ORG_NAME, ORG_DESCRIPTION, JOB_TITLE — translated posting title and organization descriptive text.
• BRIEF_DESCRIPTION, DETAILED_DESCRIPTION, JOB_REQUIREMENTS, ADDITIONAL_DETAILS, HOW_TO_APPLY — the substantive posting body text in the session language.
• IMAGE_URL, IMAGE_URL_ALT, BENEFIT_INFO — media and benefit content attached to the posting.
• DISPLAY_MANAGER_INFO, DISPLAY_RECRUITER_INFO — flags controlling whether manager/recruiter contact information is surfaced.
• ATTRIBUTE1–30, ATTRIBUTE_CATEGORY — descriptive flexfield segments for extensible posting attributes.
• IPC_INFORMATION_CATEGORY, IPC_INFORMATION1–30 — the posting content's own information/DFF context columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER — standard WHO audit and optimistic locking columns.

Common Use Cases and Queries

Typical scenarios include generating posting content extracts for external job boards, building custom iRecruitment reports that must display translated posting text, auditing DFF attribute usage, and integrating posting descriptions into downstream HR or intranet systems.

Retrieve all posting content for the current session language:

• SELECT posting_content_id, name, job_title, brief_description FROM irc_posting_contents_vl;

Filter by a specific posting content record:

• SELECT posting_content_id, org_name, detailed_description, how_to_apply FROM irc_posting_contents_vl WHERE posting_content_id = :p_content_id;

Report DFF attributes and manager/recruiter display flags:

• SELECT posting_content_id, display_manager_info, display_recruiter_info, attribute_category, attribute1, attribute2 FROM irc_posting_contents_vl;

Because language resolution is handled internally, queries against this view require no explicit join to IRC_POSTING_CONTENTS_TL. Users searching for "manager_email" should note that the view exposes the DISPLAY_MANAGER_INFO flag rather than an email column; manager contact details are obtained from the associated person/assignment data and controlled by that flag.