Search Results gma_proccol_wf_tl




Overview
Explore in AI Chat

Overview

GMA_PROCCOL_WF_TL is a translation table in the Oracle E-Business Suite Process Manufacturing Systems (GMA) module. It stores translated column prompts that drive multilingual display of process manufacturing workflow screens and column headers. The "_TL" suffix designates a translation-language table, meaning the base (untranslated) rows reside in a companion table — in this case GMA_PROCCOL_WF_B — while this table holds the language-specific prompt text keyed by LANGUAGE.

The table's function is to provide multi-lingual support for the column prompts used within the Process Manufacturing workflow configuration framework. Each row associates an Oracle Workflow item type and process with a specific table and column, and supplies the display prompt for that column in a given installed language. This allows a single workflow definition to render its user-facing labels in the appropriate language for each user without duplicating the underlying workflow structure.

From a data modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is standalone. In Data Vault terms, this suggests the object behaves as an independent reference or lookup structure rather than acting as a hub, link, or satellite within a larger integrated model. Because it carries descriptive translated text, it could alternatively be modeled as a reference satellite if a parent business key were established, but the documented relationship structure does not evidence such a parent dependency.

Key Information Stored

The table contains 14 documented columns in the 12.2.2 physical schema. The most significant are:

  • WF_ITEM_TYPE — The Oracle Workflow item type identifier. This is the top-level discriminator that scopes which workflow definition the prompt belongs to.
  • PROCESS_NAME — The workflow process name within the item type. Together with WF_ITEM_TYPE it identifies the specific process whose column prompts are being translated.
  • TABLE_NAME — The database table whose column is being prompted. This ties the translation to a concrete schema object.
  • COLUMN_NAME — The specific column within TABLE_NAME for which the prompt is defined.
  • LANGUAGE — The NLS language code (e.g., US, D, F) identifying the locale of the COLUMN_PROMPT text.
  • COLUMN_PROMPT — The translated user-facing prompt string displayed for the column. This is the primary payload of the table.
  • SOURCE_LANG — Indicates the source language from which the translation was derived, supporting translation provenance and the standard EBS translation workflow.
  • COLUMN_HIERARCHY — Ordinal or hierarchy information used to control the display ordering or grouping of prompts.
  • ZD_EDITION_NAME — The editioning column introduced for Online Patching (Edition-Based Redefinition) in EBS 12.2, enabling non-disruptive upgrades.
  • Standard WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide the standard Oracle Applications audit trail for each row.

The primary key is GMA_PROCCOL_WF_TL_PK. The documented unique index candidate is (WF_ITEM_TYPE, PROCESS_NAME, TABLE_NAME, COLUMN_NAME, LANGUAGE, ZD_EDITION_NAME), which confirms that the combination of workflow item type, process, table, column, and language uniquely identifies a translated prompt. The surrogate key is therefore composite and business-derived rather than system-generated.

Common Use Cases and Queries

The principal use case is retrieving the localized column prompt for a given workflow process and column. A typical query joins the translation table to its base table to fall back on the base-language prompt when no translation exists for the user's session language.

A common pattern retrieves prompts for a specific item type and language:

  • SELECT TABLE_NAME, COLUMN_NAME, COLUMN_PROMPT FROM GMA_PROCCOL_WF_TL WHERE WF_ITEM_TYPE = :item_type AND PROCESS_NAME = :process_name AND LANGUAGE = :language ORDER BY COLUMN_HIERARCHY;

Administrators use this table to audit which workflow columns have translated prompts and to identify missing translations by comparing LANGUAGE coverage against the set of installed languages. Reporting scenarios include generating translation coverage reports, exporting prompt strings for external translation vendors, and validating that no duplicate business keys exist across editions.

When querying in a 12.2 environment, the ZD_EDITION_NAME column should be included in the predicate — typically filtering to the current edition (often the value 'ORA$BASE' or the active edition) — to avoid returning rows from multiple editions during an online patching cycle.

Related Objects

The following objects are most significant in relation to GMA_PROCCOL_WF_TL:

  • GMA_PROCCOL_WF_B — The base table holding the untranslated column prompts. It shares the same business key columns (WF_ITEM_TYPE, PROCESS_NAME, TABLE_NAME, COLUMN_NAME) and is joined to the _TL table on those columns plus LANGUAGE to resolve display text.
  • GMA_PROCCOL_WF_VL — The MLS view that outer-joins the base and translation tables to present prompts in the session language, providing a single queryable interface.
  • WF_ITEM_TYPES / WF_ITEM_TYPE tables — Oracle Workflow metadata defining the item types referenced by WF_ITEM_TYPE.
  • WF_PROCESS_ACTIVITIES — Workflow process definitions that reference the PROCESS_NAME values stored here.
  • FND_LANGUAGES — The language lookup providing valid values for the LANGUAGE column.

Because the heuristic classification is standalone, no documented foreign key joins link this table to external parent tables; relationships above are established through shared business-key columns rather than enforced referential constraints.