Search Results po_control_functions




Overview
Explore in AI Chat

Overview

PO_CONTROL_FUNCTIONS is a Purchasing (PO) module reference and control table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the control functions that govern document type behavior — the configurable rules that determine which actions are permitted on a purchasing document of a given type and subtype. Each row binds an action type to a document type/subtype combination and can be scoped to a specific operating unit through ORG_ID, which allows organizations to tailor document control behavior without modifying seeded definitions.

Under the ETRM 12.2.2 physical schema the table is owned by the PO schema, carries 34 columns, and is secured by a primary key plus two unique business-key indexes. The heuristic Data Vault classification mined from the foreign-key structure is hub-leaning: the table behaves as a durable, relatively low-volatility set of reference entities addressed by a surrogate key, with transactional child tables pointing at it. In a Data Vault model this would be represented as a hub on CONTROL_FUNCTION_ID, with descriptive attributes (name, description, enabled flag, audit columns) carried in a satellite and the action/document combinations treated as additional business keys.

Key Information Stored

The most significant columns are:

Common Use Cases and Queries

Typical uses include diagnosing why an action is blocked on a document, auditing operating-unit-specific configuration, and building extracts that feed downstream approval or workflow logic. A frequent pattern joins the control function to its dependent position-control rows:

SELECT cf.control_function_id, cf.control_function_name, cf.action_type_code,
  cf.document_type_code, cf.document_subtype, cf.enabled_flag
FROM po.po_control_functions cf
WHERE cf.org_id = :org_id
  AND cf.enabled_flag = 'Y';

To find all position controls bound to a given control function:

SELECT p.position_id, p.control_function_id
FROM po.po_position_controls_all p
WHERE p.control_function_id = :control_function_id;

Lookups by CONTROL_FUNCTION_ID or CONTROL_FUNCTION_NAME are the most common access paths, both served by the primary key and unique indexes. Reporting on ACTION_TYPE_CODE and DOCUMENT_TYPE_CODE supports configuration inventories across operating units.

Related Objects

  • PO_POSITION_CONTROLS_ALL — the primary dependent table; its CONTROL_FUNCTION_ID column has a foreign key to PO_CONTROL_FUNCTIONS, linking control functions to position-level controls.
  • PO_CONTROL_FUNCTIONS_PK — the primary key index on CONTROL_FUNCTION_ID.
  • PO_CONTROL_FUNCTIONS_U2 — unique index on CONTROL_FUNCTION_NAME, ORG_ID, and ZD_EDITION_NAME.
  • PO_CONTROL_FUNCTIONS_U3 — unique index on ACTION_TYPE_CODE, DOCUMENT_TYPE_CODE, DOCUMENT_SUBTYPE, and ZD_EDITION_NAME.
  • PO_LOOKUP_CODES / PO_DOCUMENT_TYPES_ALL — supply the action and document type code values referenced by this table's columns.
  • HR_ALL_ORGANIZATION_UNITS — resolves ORG_ID to the operating unit name.