Results for “fnd_responsibility_tl”

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

Overview

FND_RESPONSIBILITY_TL is the translation (TL) table for FND_RESPONSIBILITY in the Oracle E-Business Suite Application Object Library (FND). It resides in the APPLSYS schema and is marked VALID in the ETRM 12.1.1 / 12.2.2 data model. The base table FND_RESPONSIBILITY stores the functional definition of a responsibility — the permission set that grants users access to menus, functions, and data. Because the responsibility name visible to end users must be presented in each installed language, the multilingual architecture splits that translatable text into this companion table. Each row holds the language-specific rendering of a responsibility's name and description, keyed back to the base record. From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is satellite-leaning. This is a modeling suggestion rather than a physical mandate: the table behaves like a satellite attached to the FND_RESPONSIBILITY hub, carrying descriptive, language-dependent attributes keyed by the parent's composite business key plus LANGUAGE.

Key Information Stored

The table documents 12 columns. The most significant are:

• APPLICATION_ID — Identifies the owning application; part of every key and part of the foreign key to FND_RESPONSIBILITY.
• RESPONSIBILITY_ID — The surrogate identifier for the responsibility; completes the FK join to the base table.
• LANGUAGE — The NLS language code for this translation row.
• RESPONSIBILITY_NAME — The translated, user-visible name of the responsibility; a business-key candidate.
• DESCRIPTION — The translated descriptive text for the responsibility.
• SOURCE_LANG — The language in which the source record was originally created, used by the translation framework.
• ZD_EDITION_NAME — The editioning column introduced in 12.2 for online patching; it appears in both unique indexes and in the 12.2.2 physical schema.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking insert and update provenance.

The surrogate primary key is FND_RESPONSIBILITY_TL_PK over (APPLICATION_ID, RESPONSIBILITY_ID, LANGUAGE). Two unique indexes act as business-key candidates: FND_RESPONSIBILITY_TL_U1 (APPLICATION_ID, RESPONSIBILITY_ID, LANGUAGE, ZD_EDITION_NAME) and FND_RESPONSIBILITY_TL_U2 (APPLICATION_ID, RESPONSIBILITY_NAME, LANGUAGE, ZD_EDITION_NAME). The ETRM excerpt also lists FND_RESPONSIBILITY_TL_UK1 over (APPLICATION_ID, RESPONSIBILITY_NAME, LANGUAGE), reinforcing that a responsibility name must be unique per application and language.

Common Use Cases and Queries

Typical reporting joins the translation table to its base table to return a responsibility by its display name, or lists all installed-language translations for a given responsibility.

• Resolve a responsibility by name: SELECT r.responsibility_id, tl.responsibility_name FROM fnd_responsibility r, fnd_responsibility_tl tl WHERE r.application_id = tl.application_id AND r.responsibility_id = tl.responsibility_id AND tl.language = USERENV('LANG');
• List multilingual translations: filter on RESPONSIBILITY_ID and APPLICATION_ID, omitting the language predicate to see every language.
• Security and access reporting: join to FND_USER_RESP_GROUPS to report which users hold which named responsibilities.

Because the base columns are language-dependent, always constrain LANGUAGE (commonly via USERENV('LANG')) to avoid duplicate rows per responsibility in reports.

Related Objects

• FND_RESPONSIBILITY — the parent base table; joined on APPLICATION_ID and RESPONSIBILITY_ID. This is the documented foreign-key relationship.
• FND_APPLICATION / FND_APPLICATION_TL — supplies the application name matching APPLICATION_ID.
• FND_USER_RESP_GROUPS — assigns responsibilities to users and responsibility groups.
• FND_MENUS / FND_MENUS_TL — the menu hierarchy attached to each responsibility.
• FND_RESPONSIBILITY_VL — the view that exposes base plus translated columns for convenience.
• FND_REQUEST_GROUPS — request group grants tied to responsibilities.