Results for “change_accepted_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PO_GA_ORG_ASSIGN_DRAFT is a Purchasing (PO) module table that stores Global Agreements Org Assignments in a draft state. It resides in the PO schema and is classified as VALID in Oracle EBS 12.1.1 and 12.2.2. Global agreements are purchasing documents negotiated centrally and then assigned to one or more operating units (organizations) so that they become usable across those organizations. The draft table captures the intended organization-level assignments associated with an unpublished purchasing document draft, allowing buyers and sourcing administrators to stage, review, and modify assignment details before the draft is finalized and promoted to the live global agreement structures.

Because global agreement assignments are naturally dependent child records of a parent purchasing draft, the table behaves as a detail entity that records which organizations a given global agreement will serve. In Data Vault terms, the mined foreign-key structure suggests a satellite-leaning classification: the table stores descriptive and state attributes (enablement, vendor site, change status) keyed to a parent draft hub. This classification is a modeling suggestion only; the physical table nonetheless functions as a normalized transactional detail table with composite primary keys and business-key unique constraints.

Key Information Stored

The table contains 15 documented columns. The most significant are as follows.

• ORG_ASSIGNMENT_ID — Part of the composite primary key (PO_GA_ORG_ASSIGN_DRAFT_PK) and of unique index U2. It is the surrogate identifier for an individual organization assignment row.
• DRAFT_ID — The other component of the primary key and the foreign key to PO_DRAFTS. It ties each assignment to its parent global agreement draft.
• PO_HEADER_ID — Identifies the purchasing document (global agreement) header being assigned. Combined with ORGANIZATION_ID and DRAFT_ID, it forms unique index U1, a strong business-key candidate.
• ORGANIZATION_ID — The operating unit receiving the assignment. Together with PO_HEADER_ID and DRAFT_ID it enforces one assignment per organization per agreement per draft.
• ENABLED_FLAG — Indicates whether the organization assignment is active for use.
• DELETE_FLAG — Marks the assignment as logically deleted within the draft.
• CHANGE_STATUS — Tracks the draft-level change state of the assignment (for example, pending addition or modification).
• CHANGE_ACCEPTED_FLAG — Records whether an initiated change has been accepted.
• VENDOR_SITE_ID — References the vendor site applicable to the assignment, where a site-specific association exists.
• PURCHASING_ORG_ID — Identifies the purchasing organization context for the assignment.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who created and last modified each row and when.

Common Use Cases and Queries

Typical scenarios include validating that a global agreement draft has been assigned to the correct set of operating units before publication, auditing pending changes, and reconciling draft assignments against their published counterparts.

Listing all organization assignments for a given draft:

• SELECT organization_id, po_header_id, enabled_flag, change_status FROM po.po_ga_org_assign_draft WHERE draft_id = :draft_id;

Finding assignable drafts for a specific operating unit:

• SELECT draft_id, po_header_id, change_status FROM po.po_ga_org_assign_draft WHERE organization_id = :org_id AND NVL(delete_flag,'N') = 'N';

Reports frequently join to PO_DRAFTS to resolve draft description and status, and to PO_HEADERS to retrieve agreement number and supplier information.

Related Objects

• PO_DRAFTS — Parent table; join on PO_GA_ORG_ASSIGN_DRAFT.DRAFT_ID = PO_DRAFTS.DRAFT_ID. This is the only documented foreign key and the primary dependency.
• PO_HEADERS — Join on PO_HEADER_ID to retrieve the global agreement document header details.
• PO_HEADERS_ALL — Operational view of purchasing document headers for reporting on the underlying agreement.
• HR_OPERATING_UNITS / HR_ALL_ORGANIZATION_UNITS — Join on ORGANIZATION_ID to resolve operating unit names.
• PO_VENDOR_SITES_ALL — Join on VENDOR_SITE_ID to resolve supplier site details.
• PO_GA_ORG_ASSIGNMENTS — The published (non-draft) counterpart table; use for reconciliation between staged and live assignments.
• PO_DRAFT_CHANGES — Supports tracking of change records associated with drafts referenced by DRAFT_ID.