Results for “xdp_proc_body_tl”

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

Overview

XDP_PROC_BODY_TL is the Multi-Language Support (MLS) translation table for XDP_PROC_BODY within the Oracle EBS XDP – Provisioning module. It stores language-specific descriptive attributes for procedure bodies defined in the base table, enabling deployments that run multiple installed languages to present display names and descriptions in the session language of the user. The table resides in the XDP schema and is classified as VALID in the ETRM repository. It is documented at both the 12.1.1 and 12.2.2 release levels, with the 12.2.2 physical schema comprising twelve columns.

Under the heuristic Data Vault classification supplied in the metadata, XDP_PROC_BODY_TL is characterized as satellite-leaning. In Data Vault modeling terms this suggests the table behaves as a descriptive satellite: it hangs off a parent business key (PROC_NAME, sourced from XDP_PROC_BODY) and carries context-dependent, non-key descriptive attributes qualified by LANGUAGE. Modelers should treat the base table as the hub or parent and this table as the satellite that records attribute history and translations, rather than a hub or link in its own right.

Key Information Stored

The table's primary key, XDP_PROC_BODY_TL_PK, is a composite surrogate key over (PROC_NAME, LANGUAGE). PROC_NAME is both the identifier of the parent procedure body and the foreign key to XDP_PROC_BODY, while LANGUAGE identifies the installed language of the translation row.

• PROC_NAME — business key of the parent XDP_PROC_BODY record; also the FK to that table and part of the primary key.
• LANGUAGE — the language code for the translated content; part of the primary key.
• SOURCE_LANG — indicates the source language from which the row was derived, supporting MLS maintenance conventions.
• DISPLAY_NAME — the language-specific display label for the procedure body.
• DESCRIPTION — the language-specific descriptive text.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing row-level security across operating units or security groups.
• ZD_EDITION_NAME — edition identifier supporting Oracle EBS Edition-Based Redefinition (EBR) in 12.2.x.
• AUDIT columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture standard who-column audit information.

The documented unique index XDP_PROC_BODY_TL_U1 covers (PROC_NAME, LANGUAGE, ZD_EDITION_NAME) and represents the business-key candidate, extending the primary key with the edition qualifier to allow multiple editioned versions of the same translation.

Common Use Cases and Queries

Typical usage centers on joining the translation table to the base table to report procedure body metadata in a specific installed language. A representative query pattern:

• SELECT b.PROC_NAME, t.DISPLAY_NAME, t.DESCRIPTION FROM XDP_PROC_BODY_TL t, XDP_PROC_BODY b WHERE t.PROC_NAME = b.PROC_NAME AND t.LANGUAGE = USERENV('LANG') AND t.ZD_EDITION_NAME = 'SET1';
• Filter by SOURCE_LANG to identify translations still pending or inherited from the source language.
• Join to FND_SECURITY_GROUPS on SECURITY_GROUP_ID to enforce operating-unit security in custom reports.
• Audit queries against LAST_UPDATE_DATE and LAST_UPDATED_BY to track translation maintenance activity.
• Detect missing translations by comparing the set of languages present in XDP_PROC_BODY_TL against the installed languages defined in FND_LANGUAGES.

Report writers should always constrain on the current edition (ZD_EDITION_NAME) in 12.2.x environments, because the EBR model can return multiple editions of the same logical row.

Related Objects

• XDP_PROC_BODY — parent table; joined on XDP_PROC_BODY_TL.PROC_NAME = XDP_PROC_BODY.PROC_NAME. Supplies the base procedure body definition.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for row-level security.
• FND_LANGUAGES — supplies the installed language set that qualifies LANGUAGE values.
• XDP_PROC_BODY_TL_PK — composite primary key constraint over (PROC_NAME, LANGUAGE).
• XDP_PROC_BODY_TL_U1 — unique business-key index over (PROC_NAME, LANGUAGE, ZD_EDITION_NAME).
• ZD_EDITION_NAME — edition identifier tying rows to EBR editions in 12.2.x.

Because the table is MLS and edition-aware, any custom integration that inserts or updates rows must supply valid PROC_NAME, LANGUAGE, SECURITY_GROUP_ID, and ZD_EDITION_NAME values consistent with the parent record and the active edition.