Search Results gma_actcol_wf_tl




Overview
Explore in AI Chat

Overview

GMA_ACTCOL_WF_TL is a translation (TL) table in the GMA schema, belonging to the Process Manufacturing Systems product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores language-specific prompt and display information for the columns that participate in Oracle Workflow–enabled activity definitions used by Process Manufacturing. In practical terms, the table provides the multilingual text layer that the Workflow activity column mechanism uses when rendering or validating activity attributes, while the base (non-translated) definition resides in the sibling table GMA_ACTCOL_WF.

The table's documented purpose is to support the availability check on Activity Identification in GMA_ACTDEF_WF before a row is inserted into GMA_ACTCOL_WF. That is, when an activity column is configured, the system validates that the parent activity definition exists, and this translation table carries the localized column prompts associated with that configuration. The heuristic Data Vault classification mined from the foreign-key structure is standalone. From a modeling perspective, this suggests the object behaves independently rather than as a classic hub, link, or satellite; where a Data Vault-style interpretation is applied, it most closely resembles a descriptive satellite keyed by the activity and column identity, but the metadata does not confirm a mandatory parent link. The object holds a VALID status in the ETRM dictionary.

Key Information Stored

GMA_ACTCOL_WF_TL contains 13 documented columns. The most important are:

  • ACTIVITY_ID — identifies the Workflow activity definition to which the column belongs; a component of the business key.
  • TABLE_NAME — the database table the activity column is associated with; a component of the business key.
  • COLUMN_NAME — the specific column being configured for the activity; a component of the business key.
  • LANGUAGE — the language code for the translated text; a component of the business key and the driver of the TL behavior.
  • SOURCE_LANG — the source language from which the translation was derived.
  • COLUMN_PROMPT — the localized display prompt shown for the column in the Workflow activity UI.
  • COLUMN_HIERARCHY — ordering or hierarchy information used to position the column within the activity.
  • ZD_EDITION_NAME — the editioning column introduced for online patching in 12.2.2; it participates in the unique index.
  • Standard audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — capture who created and last modified each translation row.

The documented surrogate/business unique key is GMA_ACTCOL_WF_TL_UK, defined over (ACTIVITY_ID, TABLE_NAME, COLUMN_NAME, LANGUAGE) and extended in 12.2.2 to include ZD_EDITION_NAME. No separate single-column surrogate primary key is documented; the composite unique index serves as the business-key candidate.

Common Use Cases and Queries

Typical scenarios include verifying that a translated prompt exists for every active language before deploying an activity definition, back-filling missing translations after a language is added, and reporting on activity column configuration across locales.

  • Retrieve the localized prompts for a given activity: SELECT COLUMN_NAME, COLUMN_PROMPT FROM GMA_ACTCOL_WF_TL WHERE ACTIVITY_ID = :id AND LANGUAGE = USERENV('LANG');
  • Detect missing translations by comparing expected languages against those present: SELECT ACTIVITY_ID, TABLE_NAME, COLUMN_NAME FROM GMA_ACTCOL_WF_TL GROUP BY ACTIVITY_ID, TABLE_NAME, COLUMN_NAME HAVING COUNT(DISTINCT LANGUAGE) < :expected;
  • Audit recently changed prompts: filter on LAST_UPDATE_DATE and LAST_UPDATED_BY.
  • Join to GMA_ACTCOL_WF on the shared business-key columns to view base and translated values side by side.

Related Objects

  • GMA_ACTCOL_WF — the base activity column definition; joined on ACTIVITY_ID, TABLE_NAME, and COLUMN_NAME.
  • GMA_ACTDEF_WF — the activity definition table validated before inserting into GMA_ACTCOL_WF; joined on ACTIVITY_ID.
  • FND_LANGUAGES — reference for valid LANGUAGE and SOURCE_LANG codes.
  • FND_APPLICATION / FND_PRODUCT_INSTALLATIONS — context for the owning GMA application and enabled languages.
  • Oracle Workflow (WF_*) views and APIs — consume activity and attribute metadata at runtime for notification and process rendering.

Because the mined classification is standalone, no enforced foreign-key dependencies are documented on this object; joins to the above are therefore logical rather than declarative.