Search Results gma_actcol_wf_vl




Overview
Explore in AI Chat

Overview

GMA_ACTCOL_WF_VL is a seeded, read-only view owned by the APPS schema within the Process Manufacturing Systems (GMA) product family. In Oracle EBS 12.1.1 and 12.2.2 it functions as a translation-enabled ("_VL") reporting and lookup layer over activity column workflow definitions. Its documented purpose is to fetch the data used to populate column prompts — the user-facing labels displayed for the columns of a workflow activity when a runtime form or workflow-driven page renders a table's fields.

Because the view resolves the language-specific prompt through USERENV('LANG'), it returns prompt text in the session's language rather than in the base language of the definition. This makes it the appropriate source for reporting, personalization, and integration components that must display a prompt that matches the end user's locale. As an APPS-owned view exposed through the EBS foundation, it is typically granted to the APPS and reporting responsibilities and is consumed by forms, concurrent programs, and OAF-based pages, but it holds no data of its own and performs no DML.

Underlying Base Objects

The view is defined over two documented base objects, both referenced as synonyms in the ETRM 12.2.2 metadata:

  • GMA_ACTCOL_WF_B — the base ("_B") table storing the language-independent definition of each activity column, including the activity identifier, table name, column name, and LOV configuration.
  • GMA_ACTCOL_WF_TL — the translation ("_TL") table storing the language-specific column prompt text keyed by activity, table, and column.

The defining SQL joins the two on ACTIVITY_ID, TABLE_NAME, and COLUMN_NAME, and filters the translation row with T.LANGUAGE = USERENV('LANG'). It selects B.ROWID as ROW_ID along with the standard _B audit columns, and surfaces T.COLUMN_PROMPT. The synonym indirection means the view's effective base objects resolve at runtime to the underlying GMA tables.

Key Columns

  • ACTIVITY_ID — identifies the workflow activity to which the column definition belongs; the primary join key to activity metadata.
  • TABLE_NAME and COLUMN_NAME — the database table and column the prompt describes; together with ACTIVITY_ID they form the logical key linking base and translation rows.
  • COLUMN_PROMPT — the translated, user-facing prompt rendered for the column; the view's principal output.
  • LOV_TABLE and LOV_COLUMN — the list-of-values source table and column to which the column is bound, if any.
  • COLUMN_HIERARCHY — groups or orders columns within the activity's presentation hierarchy.
  • ROW_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit and row identification columns inherited from the _B record.

Common Use Cases and Queries

Typical scenarios include resolving the display prompt for a given activity and column, auditing which columns are configured for an activity, and driving dynamic LOV or prompt rendering in custom reports and integrations. Because the view already filters to the session language, callers should not add their own language predicate. A representative query is:

  • SELECT activity_id, table_name, column_name, column_prompt, lov_table, lov_column FROM apps.gma_actcol_wf_vl WHERE activity_id = :p_activity_id ORDER BY column_hierarchy;
  • Joining to activity metadata by ACTIVITY_ID to build a complete activity-to-column-prompt listing for a report.

Consumers should treat the view as read-only, avoid unfiltered full scans on large installations, and rely on it rather than the underlying _B/_TL tables when translated prompt text is required. Note the view's metadata is documented for ETRM 12.2.2 and applies equally to 12.1.1, where the same GMA objects are seeded as part of the Process Manufacturing Systems schema.