Search Results gma_actcol_wf_b_uk

Overview

GMA_ACTCOL_WF_B is a table owned by the GMA schema within Oracle E-Business Suite's Process Manufacturing Systems module. It stores the seed data that defines the association between a workflow role definition and the specific database tables and columns to which that role applies, and it also captures the hierarchy of the role across those columns. This object supports the form where the actual role-to-column assignments are surfaced and maintained, making it a configuration backbone for column-level security and workflow activity control in Process Manufacturing.

From a Data Vault modeling perspective, the metadata's heuristic classification places this object as standalone, with no foreign key dependencies mined from its structure. In practice it functions as a reference or seed entity: its primary key rows describe configuration rather than transactional events, and the ETRM documentation does not model it as a hub, link, or satellite. Treating it as an independent reference table is the appropriate modeling suggestion, since it neither receives nor retains FK-driven relationship data.

Key Information Stored

The table is documented with twelve physical columns. The most significant are:

• ACTIVITY_ID – Identifies the workflow activity or role definition to which the column association belongs. It participates in both the primary key and the unique key.
• TABLE_NAME – The database table to which the role is associated.
• COLUMN_NAME – The specific field within that table that the role governs.
• COLUMN_HIERARCHY – Defines the hierarchy of the role across associated columns; this is a business-key component.
• LOV_TABLE – The lookup table used to populate values for the associated column.
• LOV_COLUMN – The lookup column whose values are presented for the associated field.
• LAST_UPDATE_LOGIN, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE – Standard EBS audit columns identifying who created or last changed each row and when.
• ZD_EDITION_NAME – The editioning column used in EBS 12.2.x for online patching and multi-edition data separation.

The surrogate primary key is GMA_ACTCOL_WF_B_PK, covering ACTIVITY_ID, TABLE_NAME, and COLUMN_NAME (plus ZD_EDITION_NAME in the 12.2.2 physical schema). The business-key candidate is the unique index GMA_ACTCOL_WF_B_UK, covering ACTIVITY_ID, COLUMN_HIERARCHY, and ZD_EDITION_NAME, which enforces uniqueness of role hierarchy per activity.

Common Use Cases and Queries

Typical usage includes tracing which columns a given workflow role can act upon, resolving the lookup source for a secured column, and auditing role hierarchy configuration. A common pattern retrieves all column associations for a single activity:

• SELECT activity_id, table_name, column_name, column_hierarchy FROM gma.gma_actcol_wf_b WHERE activity_id = :p_activity_id ORDER BY column_hierarchy;
• SELECT b.table_name, b.column_name, b.lov_table, b.lov_column FROM gma.gma_actcol_wf_b b WHERE b.table_name = :p_table ORDER BY b.column_name;
• Reporting queries join this seed data to the actual role assignments to detect configured roles that lack a matching column definition, or to list LOV sources mapped to a secured field.

Because the table is standalone and holds configuration rather than transactional volume, queries are lightweight and are generally driven by ACTIVITY_ID or TABLE_NAME predicates against the primary key and unique key indexes.

Related Objects

The ETRM metadata does not document explicit foreign keys for this object, so relationships are inference-based through shared business keys rather than enforced constraints. The most significant related objects are:

• GMA_ACTCOL_WF_TL – The translated/child counterpart storing language-specific text for the same ACTIVITY_ID and column association.
• GMA_ACTCOL_WF_B_PK and GMA_ACTCOL_WF_B_UK – The primary and unique indexes that govern the object's uniqueness and drive query performance.
• Workflow role and activity definition tables in the GMA module, joined on ACTIVITY_ID, which supply the role definitions referenced here.
• The Process Manufacturing security/role setup form documented as the consumer of this seed data, which reads and maintains the associations stored in this table.
• LOV_TABLE / LOV_COLUMN targets – The lookup tables referenced by these columns, joined dynamically to resolve permissible values for a secured field.

Consumers should treat relationships as logical, since no FK structure is documented in the ETRM 12.2.2 schema for this object.