Search Results gma_proccol_wf_b




Overview
Explore in AI Chat

Overview

GMA_PROCCOL_WF_B is a configuration table owned by the GMA schema (Process Manufacturing Systems) in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores information about configuration columns at the workflow process level. Each row defines a column that administrators can expose or customize when tuning the behavior of an approval workflow, such as the Process Manufacturing approval flows orchestrated through Oracle Workflow. The rows function as seed data for the Workflow Process Configuration screen, meaning the content of this table drives the list of configurable columns presented to users during workflow setup rather than capturing transactional approval data itself.

The table is a reference and metadata definition object. From a heuristic Data Vault modeling perspective, it would most naturally be classified as a satellite-like reference object attached to a workflow process business key, since it holds descriptive attributes (prompts, list-of-values definitions) keyed by workflow item type and process name. In the delivered ETRM documentation the relationship data classifies it as standalone, with no foreign key dependencies mined from the schema.

Key Information Stored

The table contains 14 documented columns. The most important are:

  • WF_ITEM_TYPE — the Oracle Workflow item type that identifies the workflow family (for example, the Process Manufacturing approval workflow).
  • PROCESS_NAME — the specific workflow process within that item type to which the configuration column applies.
  • TABLE_NAME — the underlying database table from which the configurable column originates.
  • COLUMN_NAME — the physical column name on that table.
  • COLUMN_HIERARCHY — defines the hierarchical position or grouping of the column within the configuration screen, and forms part of the business-key unique index.
  • COLUMN_PROMPT — the display label shown to the user for the configurable column.
  • LOV_TABLE and LOV_COLUMN — define the list-of-values source table and its display column, enabling validated selection.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.
  • ZD_EDITION_NAME — the editioning column supporting the Online Patching / Edition-Based Redefinition features introduced in EBS 12.2.

The primary key GMA_PROCCOL_WF_B_PK is the surrogate-style composite of WF_ITEM_TYPE, PROCESS_NAME, TABLE_NAME, COLUMN_NAME, and ZD_EDITION_NAME. The business-key candidate GMA_PROCCOL_WF_B_UK is the unique index on WF_ITEM_TYPE, PROCESS_NAME, COLUMN_HIERARCHY, and ZD_EDITION_NAME, which enforces that each configurable column occupies a distinct position within a given workflow process.

Common Use Cases and Queries

Typical usage centers on interrogating which columns are available for configuration on a given workflow, and how they are presented. A common query retrieves the configuration layout for a specific item type and process:

  • SELECT column_name, column_prompt, column_hierarchy, lov_table, lov_column FROM gma.gma_proccol_wf_b WHERE wf_item_type = :item_type AND process_name = :process ORDER BY column_hierarchy;
  • Listing all configurable columns for an item type: SELECT DISTINCT table_name, column_name FROM gma.gma_proccol_wf_b WHERE wf_item_type = :item_type;

Reporting scenarios include auditing which columns have list-of-values definitions versus free-text entry, validating that seeded prompts match business naming conventions, and troubleshooting the Workflow Process Configuration screen when an expected column does not appear. Support analysts also use it to confirm whether customization seed data is present after patching.

Related Objects

Because the ETRM metadata classifies this object as standalone, no direct foreign keys are documented. Related objects are inferred from the shared workflow and Process Manufacturing domain:

  • Oracle Workflow base tables such as WF_ITEM_TYPES and WF_PROCESSES, joined on WF_ITEM_TYPE and PROCESS_NAME.
  • The Workflow Process Configuration screen, the form/function that consumes this table as its seed data source.
  • GMA workflow process tables that define the associated approval processes for which columns are configured.
  • GMA_PROCCOL_WF_TL, if present in a given instance, holding translatable prompt text keyed by the same business columns.
  • The LOV_TABLE / LOV_COLUMN targets — application lookup tables referenced dynamically for validated selection.

Joins to Oracle Workflow metadata views on WF_ITEM_TYPE and PROCESS_NAME provide the most reliable way to contextualize rows in this table.