Results for “agenda_id”

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

Overview

AMS_AGENDAS_TL is the translation ("TL") table for marketing agendas in the Oracle E-Business Suite Marketing (AMS) module. It holds the language-dependent, translatable textual attributes of an agenda record — specifically the agenda name and its description — for each installed language. The base, language-independent attributes of an agenda are stored in the companion base table AMS_AGENDAS_B, while AMS_AGENDAS_TL supplies the human-readable strings presented to users in their session language.

Under the heuristic Data Vault classification derived from its foreign-key structure, this object is satellite-leaning. In Data Vault modeling terms, it functions as a satellite attached to the agenda hub/key represented by AMS_AGENDAS_B, carrying descriptive and language-qualified context rather than defining new business keys of its own. It is a standard multi-language (MLS) child table, and its translation rows are maintained in lockstep with the parent agenda through the Oracle translation framework.

Key Information Stored

The most significant columns of AMS_AGENDAS_TL are:

• AGENDA_ID — The identifier that links each translation row to its parent agenda in AMS_AGENDAS_B. It is part of the composite primary key.
• LANGUAGE — The language code identifying the translation locale for the row. It is the second component of the composite primary key.
• SOURCE_LANG — The language of the source (typically the base) text from which this row was derived, used by the MLS framework to track translation provenance.
• AGENDA_NAME — The translated display name of the agenda, the primary business-facing text attribute.
• DESCRIPTION — The translated descriptive text for the agenda.
• SECURITY_GROUP_ID — The security group that governs access to the row, joining to FND_SECURITY_GROUPS.
• CREATION_DATE, CREATED_BY — Standard audit columns recording when and by whom the translation row was created.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns recording the most recent modification and the login context of the updating session.

The composite primary key is AMS_AGENDAS_TL_PK (AGENDA_ID, LANGUAGE), which is also mirrored by the unique index AMS_AGENDAS_TL_U1 (AGENDA_ID, LANGUAGE). Here AGENDA_ID serves as the foreign surrogate key to the parent base table, while the combination of AGENDA_ID and LANGUAGE constitutes the business-key candidate enforcing one translation per agenda per language. The documented table carries eleven columns in the AMS schema.

Common Use Cases and Queries

Typical uses center on retrieving localized agenda text for reporting, integration extracts, and user-interface rendering. A common pattern joins the translation table to its base table and filters on the desired language, for example:

• Retrieving a single localized agenda: SELECT t.agenda_name, t.description FROM ams.ams_agendas_tl t WHERE t.agenda_id = :agenda_id AND t.language = USERENV('LANG');
• Listing all translations for an agenda: SELECT t.language, t.agenda_name FROM ams.ams_agendas_tl t WHERE t.agenda_id = :agenda_id;
• Reporting with base-to-translation joins: SELECT b.agenda_id, t.agenda_name, t.language FROM ams.ams_agendas_b b, ams.ams_agendas_tl t WHERE b.agenda_id = t.agenda_id AND t.language = 'US';
• Auditing recently changed translations via LAST_UPDATE_DATE to reconcile integration feeds.
• Filtering by SECURITY_GROUP_ID to enforce multi-org security in reports.

Related Objects

• AMS_AGENDAS_B — The parent base table joined on AGENDA_ID; holds language-independent agenda attributes and is the referenced side of the AMS_AGENDAS_TL.AGENDA_ID foreign key.
• FND_SECURITY_GROUPS — Referenced by AMS_AGENDAS_TL.SECURITY_GROUP_ID, providing the security-group definitions used to partition data access.
• AMS_AGENDAS_TL_PK / AMS_AGENDAS_TL_U1 — The primary-key constraint and unique index enforcing uniqueness on AGENDA_ID and LANGUAGE.
• AMS_AGENDAS_VL — The MLS view typically layered over the base and translation tables for simplified localized access.
• AMS_AGENDA_* child tables — Agenda-related transactional and detail tables in the AMS schema that reference the agenda key and depend on its translated text for display.