Results for “redirection_url”

6 results




Overview
Explore in AI Chat

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

Overview

The IRC_ALL_RECRUITING_SITES_TL table is a translation (TL) table within the Oracle E-Business Suite Human Resources (PER) module, owned by the HR schema. It stores the language-specific, translated versions of recruiting site definitions used by Oracle iRecruitment. Every row in this table represents one language rendering of a recruiting site record, keyed by the combination of RECRUITING_SITE_ID and LANGUAGE. The object is classified as VALID in the ETRM registry for both Oracle EBS 12.1.1 and 12.2.2.

In the EBS multilingual architecture, a base table (typically IRC_ALL_RECRUITING_SITES_B) holds language-independent attributes, while the corresponding _TL table holds user-facing translated text such as site names and URLs. The heuristic Data Vault classification mined from the foreign key structure is standalone, meaning the modeler has not identified mandatory parent dependencies within the documented schema. In dimensional or Data Vault modeling terms, this object is best treated as a satellite attached to the recruiting site business key, since it carries descriptive, language-dependent attributes rather than acting as a hub or link in its own right.

Key Information Stored

The table contains seven documented columns. The most important of these are:

  • RECRUITING_SITE_ID — The surrogate identifier for the recruiting site. Combined with LANGUAGE, it forms the composite primary key IRC_ALL_RECRUITING_SITES_TL_PK and is the principal foreign key back to the base recruiting site entity.
  • LANGUAGE — The NLS language code identifying which translation is stored in the row. Part of the primary key.
  • SOURCE_LANG — Indicates the source language from which the translation was derived, supporting the standard EBS TL pattern used to track translation origin.
  • SITE_NAME — The translated display name of the recruiting site. This is a documented business-key candidate via the unique index IRC_ALL_REC_SITES_TL_UK1 (SITE_NAME, LANGUAGE, ZD_EDITION_NAME).
  • REDIRECTION_URL — The translated redirection URL associated with the site, used when candidates are routed elsewhere.
  • POSTING_URL — The URL at which job postings are published for the site in the given language.
  • ZD_EDITION_NAME — The editioning column introduced in EBS 12.2 Online Patching. It appears in the primary key candidates and unique indexes and is critical for edition-aware querying.

The primary key is the surrogate composite (RECRUITING_SITE_ID, LANGUAGE); the unique index IRC_ALL_REC_SITES_TL_UK1 establishes SITE_NAME as a business-key candidate. Two system LOB indexes (SYS_IL0000330749C00005$$, SYS_IL0000330749C00006$$) indicate that one or more columns—likely the URL fields—are stored as LOB segments.

Common Use Cases and Queries

The table is primarily accessed when an application or report must display recruiting site information in a specific language. Typical scenarios include iRecruitment portal rendering, multilingual reporting, and auditing which sites have translations available.

To retrieve the translated site details for a given site and language:

  • SELECT recruiting_site_id, language, site_name, posting_url, redirection_url FROM irc_all_recruiting_sites_tl WHERE recruiting_site_id = :p_site_id AND language = USERENV('LANG');
  • To list all translations for a site: SELECT language, site_name FROM irc_all_recruiting_sites_tl WHERE recruiting_site_id = :p_site_id;
  • To find sites lacking a translation in a target language: compare against IRC_ALL_RECRUITING_SITES_B in a LEFT OUTER JOIN on RECRUITING_SITE_ID.
  • In 12.2, edition-aware queries should filter or join on ZD_EDITION_NAME to avoid crossing edition boundaries.

Reporting use cases include site-name localization audits, URL configuration review, and delivering language-specific recruiting links to external job boards.

Related Objects

  • IRC_ALL_RECRUITING_SITES_B — The base (non-translated) recruiting site table; joined on RECRUITING_SITE_ID. This is the primary partner to the TL table.
  • IRC_ALL_RECRUITING_SITES_VL — The standard EBS view that joins the _B and _TL tables to expose a fully translated record.
  • IRC_RECRUITING_SITES_TL / _B — Any organization-specific or legacy variants following the same translation pattern.
  • FND_LANGUAGES — Reference table validating the LANGUAGE column values.
  • IRC_VACANCIES / IRC_POSTINGS — Recruiting entities that reference recruiting sites and inherit their localized URLs and names.
  • FND_TERRITORIES — Frequently joined to relate a recruiting site to its geographic territory.

The SITE_NAME unique index and the composite primary key together provide the primary access paths for application lookups.