Search Results po_ga_org_assignments_uk

Overview

The PO_GA_ORG_ASSIGNMENTS table is a core data object within the Oracle E-Business Suite Purchasing (PO) module, specifically for releases 12.1.1 and 12.2.2. It serves as the master repository for organization assignments related to Global Agreements. In Oracle Purchasing, a Global Agreement (often a Blanket Purchase Agreement or Contract) is a purchasing document that can be sourced by multiple operating units or inventory organizations. This table defines the specific organizations that are authorized to reference and use a given Global Agreement, thereby enforcing procurement security and control. Its role is critical in a multi-org architecture, enabling centralized sourcing while maintaining decentralized execution.

Key Information Stored

The table's structure is designed to map agreements to organizations uniquely. Based on the provided ETRM metadata, the primary columns and constraints are:

• ORG_ASSIGNMENT_ID: A unique system-generated identifier serving as the primary key for the row (PO_GA_ORG_ASSIGNMENTS_PK).
• PO_HEADER_ID: References the PO_HEADERS_ALL.PO_HEADER_ID, identifying the specific Global Agreement.
• ORGANIZATION_ID: References the HR_ORGANIZATION_UNITS.ORGANIZATION_ID, identifying the inventory organization assigned to the agreement.

The metadata indicates a strong emphasis on ensuring a unique pairing between an agreement and an organization, as evidenced by multiple unique key constraints (PO_GA_ORG_ASSIGNMENTS_UK, PO_GA_ORG_ASSIGN_PK, PO_GA_ORG_ASSIGN_UK) all on the combination of PO_HEADER_ID and ORGANIZATION_ID.

Common Use Cases and Queries

A primary use case is validating whether a user in a specific organization can use an agreement when creating a purchase order. Reporting use cases include listing all organizations assigned to a specific agreement or identifying all agreements available to a particular organization. Common SQL queries involve joining to PO_HEADERS_ALL for agreement details and HR_ORGANIZATION_UNITS for organization names.

Sample query to find agreements assigned to an organization (ID 204):

SELECT pha.segment1 agreement_num, pha.type_lookup_code, hou.name org_name
FROM po_ga_org_assignments pgoa,
    po_headers_all pha,
    hr_organization_units hou
WHERE pgoa.po_header_id = pha.po_header_id
AND pgoa.organization_id = hou.organization_id
AND pgoa.organization_id = 204;

Related Objects

This table has integral relationships with other core Purchasing and HR entities.

• PO_HEADERS_ALL: The primary parent table, supplying the Global Agreement header information via PO_HEADER_ID.
• HR_ORGANIZATION_UNITS (or INV_ORG_PARAMETERS): The parent table for the assigned inventory organization via ORGANIZATION_ID.
• PO_DISTRIBUTIONS_ALL: Purchase order distributions may reference a Global Agreement; the organization context for the distribution is validated against assignments in this table.
• Relevant APIs: Purchasing document approval and validation workflows will internally query this table to enforce organization-level security for agreements.