Search Results fnd_security_groups_tl_u1

Overview

FND_SECURITY_GROUPS_TL is the translation table for security groups in Oracle E-Business Suite, owned by the APPLSYS schema and defined in the FND design data as FND.FND_SECURITY_GROUPS_TL. In Oracle EBS 12.1.1 and 12.2.2, security groups partition application data by restricting the set of responsibilities, menus, and data that a given user session may access. The base definition of each group resides in FND_SECURITY_GROUPS, while this table stores the language-dependent attributes — the group name and description — for each installed language. One row exists per security group per language, so a group deployed in N languages produces N rows here.

The object is physically stored in the APPS_TS_SEED tablespace with PCTFREE 10 and carries the standard Oracle EBS seed-data profile: it is an APPLSYS-owned, seed-data-maintained table rather than a transactional or user-extensible structure. The heuristic Data Vault classification supplied in the metadata is standalone, meaning the mined foreign-key structure shows no outbound references; as a modeling suggestion, it is best treated as a reference/descriptive satellite of the security group entity rather than as a hub or link in its own right.

Key Information Stored

FND_SECURITY_GROUPS_TL holds eleven documented columns. The columns of operational significance are:

• SECURITY_GROUP_ID (NUMBER 15) — the surrogate identifier of the security group; together with LANGUAGE it forms the primary key FND_SECURITY_GROUPS_TL_PK.
• LANGUAGE (VARCHAR2) — the installed language the row is translated into.
• SECURITY_GROUP_NAME (VARCHAR2 80) — the user-visible name of the security group in that language.
• DESCRIPTION (VARCHAR2 240) — the translated description of the security group.
• SOURCE_LANG (VARCHAR2) — the language the text mirrors; when a translation has not yet been supplied for LANGUAGE, edits to the source-language row propagate here.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Who columns capturing row creation and last modification audit information.
• ZD_EDITION_NAME — the editioning column introduced for the 12.2 online patching / Edition-Based Redefinition model; it is part of the unique keys in 12.2.2 and is absent from the 12.1.1 physical definition.

The documented unique indexes are the business-key candidates: FND_SECURITY_GROUPS_TL_U1 on (SECURITY_GROUP_ID, LANGUAGE, ZD_EDITION_NAME) and FND_SECURITY_GROUPS_TL_U2 on (SECURITY_GROUP_NAME, LANGUAGE, ZD_EDITION_NAME). The U2 constraint — the one referenced by the "fnd_security_groups_tl_u2" search — enforces uniqueness of the security group name within a language, preventing two translated rows in the same language from sharing a display name. Both indexes reside in APPS_TS_SEED.

Common Use Cases and Queries

Typical reporting uses include listing all security groups in a specific language, resolving a user-entered group name back to its SECURITY_GROUP_ID, and auditing which groups carry a translation in a given language. Because SOURCE_LANG indicates whether a row is a genuine translation or a mirrored fallback, translation-completeness reports should compare SOURCE_LANG against LANGUAGE.

Resolving a name to an identifier:

• SELECT security_group_id, security_group_name, description FROM applsys.fnd_security_groups_tl WHERE security_group_name = :name AND language = :lang;
• SELECT t.security_group_id, t.security_group_name, b.security_group_key FROM fnd_security_groups_tl t, fnd_security_groups b WHERE t.security_group_id = b.security_group_id AND t.language = USERENV('LANG');
• SELECT l.language, t.security_group_name, t.source_lang FROM fnd_security_groups_tl t, fnd_languages l WHERE t.security_group_id = :id ORDER BY l.language;

Translation-gap detection uses a self-referencing pattern comparing SOURCE_LANG with LANGUAGE to identify rows still mirroring the source.

Related Objects

The object participates in a small dependency neighbourhood:

• FND_SECURITY_GROUPS — the untranslated parent; join on SECURITY_GROUP_ID. It supplies the security group's key, application, and other base attributes.
• APPS.FND_SECURITY_GROUPS_TL — the APPS-layer synonym/view of this table, and the object through which application code normally accesses the data.
• FND_SECURITY_GROUPS_TL_PK — the primary key on (SECURITY_GROUP_ID, LANGUAGE) enforcing one row per group per language.
• FND_SECURITY_GROUPS_TL_U1 / U2 — the unique indexes serving as business-key candidates; U2 constrains SECURITY_GROUP_NAME by language.
• FND_LANGUAGES — the reference for installed languages; join on LANGUAGE to drive language filters and translation reports.

No documented database object is referenced by FND_SECURITY_GROUPS_TL, consistent with its standalone classification; the table is a leaf translation store queried by form and concurrent-program logic rather than an owner of downstream foreign keys.