Results for “jtf_am_screen_setups_tl”

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

Overview

JTF_AM_SCREEN_SETUPS_TL is the translation (language) table for JTF_AM_SCREEN_SETUPS_B within the JTF – CRM Foundation product. Its role in Oracle EBS 12.1.1 and 12.2.2 is to hold the language-dependent, translatable attributes of Assignment Manager screen setup definitions, while the companion _B table stores the language-independent base record. Every row in the _TL table is uniquely identified by the combination of a screen setup identifier and a language code, allowing the same logical screen setup to carry distinct descriptive text per installed language.

The table is owned by the JTF schema and is documented as VALID in ETRM. The heuristic Data Vault classification derived from its foreign key structure is satellite-leaning. This is consistent with the physical design: the table depends on a parent business entity (JTF_AM_SCREEN_SETUPS_B) through a foreign key on SCREEN_SETUP_ID, and it carries descriptive, context-specific attributes rather than functioning as an independent hub or as a pure many-to-many link. Modelers should therefore treat it as a satellite of the Assignment Manager screen setup hub, with LANGUAGE acting as an additional descriptive discriminator.

Key Information Stored

The documented physical schema for 12.2.2 comprises eleven columns. The most significant are:

• SCREEN_SETUP_ID – The identifier of the parent Assignment Manager screen setup. Together with LANGUAGE it forms the primary key JTF_AM_SCREEN_SETUPS_TL_PK1.
• LANGUAGE – The NLS language code for the translation row; the second component of the composite primary key.
• PREFERENCE_NAME – The translatable preference or display name associated with the screen setup, which is the principal user-visible text held in this table.
• SOURCE_LANG – The language from which the translation was derived or seeded, used by the translation framework to track provenance.
• ZD_EDITION_NAME – The editioning column introduced by the 12.2 online patching (E-Business Suite Editioning) architecture.
• SECURITY_GROUP_ID – The security group under which the row is visible, referencing FND_SECURITY_GROUPS.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – The standard EBS auditing (WHO) columns that record row creation and modification metadata.

The surrogate primary key is the composite (SCREEN_SETUP_ID, LANGUAGE), while the unique index JTF_AM_SCREEN_SETUPS_TL_U1 on (SCREEN_SETUP_ID, LANGUAGE, ZD_EDITION_NAME) represents the business-key candidate under the editioning model. The foreign key on SCREEN_SETUP_ID to JTF_AM_SCREEN_SETUPS_B enforces referential integrity to the base table; a secondary foreign key on SECURITY_GROUP_ID references FND_SECURITY_GROUPS.

Common Use Cases and Queries

Typical reporting and integration scenarios involve retrieving translated screen setup names for a specific language, verifying that translations exist for all installed languages, and joining the translation rows back to the base table for a complete Assignment Manager screen setup definition.

• Retrieve the translated preference name for a given screen setup and language:

  SELECT t.screen_setup_id, t.language, t.preference_name
  FROM   jtf.jtf_am_screen_setups_tl t
  WHERE  t.screen_setup_id = :setup_id
  AND    t.language = USERENV('LANG');

• Identify screen setups that lack a translation for a required language by outer-joining the _B and _TL tables on SCREEN_SETUP_ID.
• List all translations, with their source language, for audit or localization review.
• Join to FND_SECURITY_GROUPS on SECURITY_GROUP_ID when reporting must be filtered by information security group.
• In 12.2 environments, restrict or include rows by ZD_EDITION_NAME when querying during or after an online patching cycle.

Related Objects

The following objects are most significant in relation to this table:

• JTF_AM_SCREEN_SETUPS_B – The base table holding language-independent screen setup data; joined on SCREEN_SETUP_ID. This is the direct parent of the translation row.
• FND_SECURITY_GROUPS – Referenced through SECURITY_GROUP_ID for row-level security group assignment.
• FND_LANGUAGES – The underlying definition of the LANGUAGE and SOURCE_LANG values (logical relationship, not a documented FK).
• JTF_AM_SCREEN_SETUPS_TL_PK1 / JTF_AM_SCREEN_SETUPS_TL_U1 – The primary key constraint and the editioning-aware unique index that enforce row uniqueness.
• Assignment Manager (JTF_AM) configuration screens and concurrent programs – The application components that read and maintain translated screen setup definitions.

Both the base table and its translation table must generally be queried together to produce complete, localized Assignment Manager screen setup output.