Search Results po_control_groups_pk

Overview

PO_CONTROL_GROUPS_ALL is a Purchasing (PO) module table that stores document authorization groups. An authorization group defines the set of control rules and position controls that govern which purchasing documents — requisitions, purchase orders, and releases — a given user or position is permitted to create, approve, or modify. The _ALL suffix indicates the table is partitioned by operating unit through the ORG_ID column, and it is one of the core configuration tables that must be set up before the Purchasing document security and approval hierarchy can function.

The ETRM documentation classifies this object as a document authorization groups table, owned by the PO schema. The metadata does not assign an explicit Data Vault classification; however, based on its foreign key profile and the presence of a single-column surrogate primary key, the heuristic classification is hub-leaning. In Data Vault modeling terms, PO_CONTROL_GROUPS_ALL behaves as a hub: it holds the business key (the authorization group name) and a generated surrogate key, while the rules and position-level controls that reference it act as satellites or links carrying the descriptive and transactional detail.

Key Information Stored

The table contains 30 documented columns. The most significant are:

• CONTROL_GROUP_ID — the system-generated surrogate primary key (PO_CONTROL_GROUPS_PK), used as the referencing column by all downstream authorization tables.
• CONTROL_GROUP_NAME — the user-facing business key, the descriptive name of the authorization group. It forms part of the unique index PO_CONTROL_GROUPS_U2, combined with ORG_ID, which enforces uniqueness of the group name within an operating unit.
• ORG_ID — the operating unit identifier that drives multi-org partitioning; combined with CONTROL_GROUP_NAME it constitutes the natural business key.
• ENABLED_FLAG — indicates whether the authorization group is active and available for assignment to users or positions.
• DESCRIPTION — free-text explanation of the group's purpose.
• ATTRIBUTE_CATEGORY plus ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS flexfield-enabled descriptive columns available for extension without schema changes, typically configured by the implementing organization to capture site-specific classification data.
• WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide the standard audit trail maintained by the EBS audit framework.
• Concurrent program columns — REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE record the program context in which the row was last touched, enabling support for batch-loaded or program-maintained configuration.

The single-column unique index PO_CONTROL_GROUPS_U1 (CONTROL_GROUP_ID) is redundant with the primary key constraint, while PO_CONTROL_GROUPS_U2 (CONTROL_GROUP_NAME, ORG_ID) is the genuine business-key candidate.

Common Use Cases and Queries

Because authorization groups are configuration data, the predominant usage is lookup and validation rather than high-volume transaction processing. Typical scenarios include identifying the active groups available in an operating unit, tracing which groups a given position is linked to, and validating that every rule defined in the system belongs to a legitimate group.

A basic lookup of active groups for an operating unit:

SELECT control_group_id, control_group_name, description
FROM po_control_groups_all
WHERE org_id = :org_id AND enabled_flag = 'Y';

Resolving the group name for a position control assignment joins PO_POSITION_CONTROLS_ALL to this table on CONTROL_GROUP_ID. A similar join from PO_CONTROL_RULES produces the full rule set that a group imposes. Reporting queries frequently use this table as a dimension, with CONTROL_GROUP_NAME as the display attribute and CONTROL_GROUP_ID as the surrogate key referenced by facts such as document approval or control-rule evaluations.

Related Objects

The FK metadata identifies the following objects as direct dependents of PO_CONTROL_GROUPS_ALL, all joining on CONTROL_GROUP_ID:

• PO_CONTROL_RULES — defines the individual authorization rules belonging to a group.
• PO_CONTROL_RULES_EFC — the error/flexfield-compatible variant of the control rules table, used in the EBS Federal/encumbrance context.
• PO_POSITION_CONTROLS_ALL — maps authorization groups to positions, completing the position-based security model.

In addition to these foreign-key dependents, the table is referenced indirectly by the Purchasing document security and approval workflows and is commonly joined with PO_POSITIONS_ALL to assemble position-level access, and with HR_ALL_ORGANIZATION_UNITS or the FND organization views to resolve ORG_ID to an operating unit name. Because it is a configuration table, it is usually populated through the Purchasing setup forms rather than by direct DML.