Search Results eam_wo_statuses_tl




Overview
Explore in AI Chat

Overview

EAM_WO_STATUSES_TL is the translation table for Work Order Statuses within the Oracle E-Business Suite Enterprise Asset Management (EAM) module. It stores the language-specific, user-facing text associated with each work order status defined in the base table EAM_WO_STATUSES_B. In a multilingual EBS implementation, the base table holds the language-independent definition of a status, while the corresponding _TL table provides the translated status name and description for each installed language.

From a Data Vault modeling perspective, the FK structure mined from this object suggests a satellite-leaning classification. The table does not introduce a new business entity of its own; instead, it depends on EAM_WO_STATUSES_B (via STATUS_ID) and carries descriptive, language-dependent attributes. Its natural fit is therefore as a satellite attached to the work order status hub or base entity, capturing the translated descriptive payload keyed by STATUS_ID and LANGUAGE. This classification is a heuristic suggestion derived from the foreign key topology rather than a formal Data Vault declaration.

Key Information Stored

Although the documented schema lists 10 columns, the most significant are the following:

  • STATUS_ID — The surrogate identifier linking each translated row to its parent work order status record in EAM_WO_STATUSES_B. It is the primary discriminator in the composite primary key.
  • LANGUAGE — The language code identifying which installed EBS language the translated text applies to. Together with STATUS_ID it forms the composite primary key EAM_WO_STATUSES_TL_PK.
  • SOURCE_LANG — Indicates the source language from which the translation was derived, supporting the standard EBS multilingual translation model.
  • USER_DEFINED_STATUS — The user-facing status text presented in the application for the given language. This column is a documented business-key candidate, forming the basis of unique index EAM_WO_STATUSES_TL_U2 (USER_DEFINED_STATUS, LANGUAGE, ZD_EDITION_NAME).
  • ZD_EDITION_NAME — The editioning or edition-based redefinition discriminator used in EBS 12.2 online patching. It appears in both unique indexes EAM_WO_STATUSES_TL_U1 and EAM_WO_STATUSES_TL_U2.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — The standard EBS audit columns tracking who created and last modified each row, and through which login.

The composite primary key (STATUS_ID, LANGUAGE) distinguishes the surrogate identity of each row, whereas the unique indexes EAM_WO_STATUSES_TL_U1 and EAM_WO_STATUSES_TL_U2 represent the business-key candidates that enforce uniqueness of the status identity across language and editioning dimensions.

Common Use Cases and Queries

This table is most often joined to its base table to render work order status labels in reports, forms, and BI Publisher outputs where status text must appear in the user's language. A typical bilingual join pattern is:

  • Reporting the status name for open work orders by joining EAM_WORK_ORDERS to EAM_WO_STATUSES_B on STATUS_ID and then to EAM_WO_STATUSES_TL on (STATUS_ID, LANGUAGE).
  • Filtering translations to a specific language, for example restricting to LANGUAGE = 'US' for English (United States).
  • Auditing available status translations across installed languages to verify that all statuses are localized before go-live.
  • Extracting user-defined status text via the EAM_WO_STATUSES_TL_U2 business-key candidate (USER_DEFINED_STATUS, LANGUAGE, ZD_EDITION_NAME).

Queries typically constrain LANGUAGE to avoid returning multiple translation rows per status, and may also reference ZD_EDITION_NAME in a 12.2 environment to select the correct edition.

Related Objects

The following objects are the most significant in relation to EAM_WO_STATUSES_TL:

  • EAM_WO_STATUSES_B — The base table containing the language-independent definition of each work order status. Joined on EAM_WO_STATUSES_TL.STATUS_ID = EAM_WO_STATUSES_B.STATUS_ID, this is the direct parent referenced by the documented foreign key.
  • EAM_WORK_ORDERS — The primary transactional table for work orders, which references status identifiers that resolve to the translated text held here.
  • EAM_WO_STATUSES_TL_PK — The primary key constraint (STATUS_ID, LANGUAGE) enforcing row uniqueness.
  • EAM_WO_STATUSES_TL_U1 — Unique index on (STATUS_ID, LANGUAGE, ZD_EDITION_NAME), a business-key candidate.
  • EAM_WO_STATUSES_TL_U2 — Unique index on (USER_DEFINED_STATUS, LANGUAGE, ZD_EDITION_NAME), a second business-key candidate.
  • EAM_WO_STATUSES_VL / _V — Conventional EBS translation views that expose the joined base and translated columns for application and reporting access.
  • FND_LANGUAGES — The EBS language reference table whose NLS_LANGUAGE_CODE/CODE values correspond to the LANGUAGE column here.