Search Results po_ga_org_assign_draft

Overview

The PO_GA_ORG_ASSIGN_DRAFT table is a critical transactional object within Oracle E-Business Suite Purchasing (PO) modules, specifically for versions 12.1.1 and 12.2.2. It functions as a staging table for organization assignments related to Global Agreements during the draft creation and modification process. A Global Agreement is a purchasing document, such as a blanket purchase agreement or a contract, that can be sourced across multiple operating units or inventory organizations. This table temporarily holds proposed changes to the list of organizations assigned to a draft agreement before the changes are finalized and published, ensuring data integrity and supporting a controlled workflow for agreement management.

Key Information Stored

The table stores the draft relationships between a Global Agreement header and the inventory organizations assigned to it. Its structure is defined by a composite primary key and a unique key to enforce data integrity. The most significant columns include ORG_ASSIGNMENT_ID, a unique system-generated identifier for each draft assignment record. The DRAFT_ID column is a foreign key linking the record to its parent draft document in the PO_DRAFTS table. The PO_HEADER_ID references the specific Global Agreement (from PO_HEADERS_ALL) being modified, and ORGANIZATION_ID specifies the inventory organization being assigned to or removed from that agreement in the draft context.

Common Use Cases and Queries

The primary use case involves reviewing or troubleshooting draft organization assignments before final approval. A common query retrieves all draft organization assignments for a specific agreement to validate changes. For example: SELECT organization_id, draft_id FROM po.po_ga_org_assign_draft WHERE po_header_id = <AGREEMENT_ID>;. Another typical scenario is identifying all drafts that propose modifying assignments for a particular organization, which aids in change impact analysis: SELECT d.draft_id, h.segment1 agreement_num FROM po.po_ga_org_assign_draft a, po.po_drafts d, po.po_headers_all h WHERE a.draft_id = d.draft_id AND a.po_header_id = h.po_header_id AND a.organization_id = <ORG_ID>;. Data in this table is transient; upon final submission and approval of the draft, these assignments are processed and typically moved to a corresponding published table, and the draft records may be purged.

Related Objects

The table maintains defined foreign key relationships with core Purchasing tables, anchoring it firmly within the data model. Its primary relationship is with the PO_DRAFTS table via the DRAFT_ID column. This link ensures every organization assignment draft is associated with a valid draft document. While not explicitly listed in the provided metadata but inferred from the column names and standard EBS design, the PO_HEADER_ID column references the PO_HEADERS_ALL table (the master table for all purchase documents), and ORGANIZATION_ID references HR_ORGANIZATION_UNITS or INV_ORG_PARAMETERS to validate the inventory organization. The documented foreign key is:

• PO_DRAFTS: Linked via PO_GA_ORG_ASSIGN_DRAFT.DRAFT_ID = PO_DRAFTS.DRAFT_ID. This is the controlling relationship for the draft lifecycle.