Results for “umbrella_program_id”
5 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PO_HEADERS_ARCHIVE_ALL is the archival table for purchase order headers in the Oracle Purchasing (PO) module. It resides in the PO schema and stores archived purchase orders that have been migrated out of the operational PO_HEADERS_ALL table. In Oracle EBS 12.1.1 and 12.2.2, the Purchasing application maintains headers, lines, and distributions across active and archive layers so that long-closed or superseded documents remain queryable without degrading transaction-table performance.
The table has 201 documented columns and is keyed on PO_HEADER_ID and REVISION_NUM via the PO_HEADERS_ARCHIVE_PK constraint. A heuristic Data Vault classification mined from the foreign-key structure places this table as satellite-leaning: it carries descriptive, revision-scoped attributes tied to a purchase order hub. Under this reading, PO_HEADER_ID would serve as the hub key, REVISION_NUM as part of the satellite key, and the descriptive columns (notes, amounts, statuses, contract metadata) as satellite attributes.
Key Information Stored
The surrogate primary key is PO_HEADER_ID combined with REVISION_NUM. Two unique business-key candidates are documented: PO_HEADERS_ARCHIVE_U1 (PO_HEADER_ID, REVISION_NUM) and PO_HEADERS_ARCHIVE_U2 (SEGMENT1, REVISION_NUM, TYPE_LOOKUP_CODE, ORG_ID). SEGMENT1 is the human-readable document number.
- PO_HEADER_ID / REVISION_NUM — surrogate identifier and document revision.
- SEGMENT1 / TYPE_LOOKUP_CODE — document number and document type (standard, blanket, contract, planned).
- FROM_HEADER_ID / FROM_TYPE_LOOKUP_CODE — linkage to the source document from which this header was derived.
- ORG_ID — operating unit, driving multi-org (MOAC) access.
- VENDOR_ID, VENDOR_SITE_ID, VENDOR_CONTACT_ID — supplier, site, and contact references.
- CURRENCY_CODE, RATE_TYPE, RATE, RATE_DATE — currency and exchange-rate attributes.
- AUTHORIZATION_STATUS, APPROVED_FLAG, APPROVED_DATE — approval state.
- CLOSED_CODE, CLOSED_DATE, CANCEL_FLAG, FROZEN_FLAG — lifecycle status.
- BLANKET_TOTAL_AMOUNT, AMOUNT_LIMIT, MIN_RELEASE_AMOUNT — agreement financials.
- NOTE_TO_VENDOR, NOTE_TO_AUTHORIZER, COMMENTS — free-text remarks.
- CONSIGNED_CONSUMPTION_FLAG, GLOBAL_AGREEMENT_FLAG, SUPPLY_AGREEMENT_FLAG — procurement flags.
- CLM_* columns — Contract Lifecycle Management (CLM) attributes such as CLM_DOCUMENT_NUMBER and CLM_AWARD_TYPE.
Common Use Cases and Queries
Typical use cases include historical PO reporting, audit and compliance retrieval, and reconciliation of archived agreements without touching live transaction tables. Queries generally filter by ORG_ID for MOAC and by SEGMENT1 for document lookup.
- Retrieve all revisions of an archived document:
SELECT PO_HEADER_ID, SEGMENT1, REVISION_NUM, AUTHORIZATION_STATUS FROM PO_HEADERS_ARCHIVE_ALL WHERE SEGMENT1 = :doc_num AND ORG_ID = :org; - List archived documents for a supplier: join VENDOR_ID to PO_VENDORS and filter on authorization status.
- Reporting on approved spend by currency and rate type using CURRENCY_CODE and RATE_TYPE.
- Reconciliation against the active layer via FROM_HEADER_ID.
Because the table is large and revision-scoped, queries should always predicate on the primary or unique key columns to avoid full scans.
Related Objects
- PO_HEADERS_ALL — joined via FROM_HEADER_ID; source of the active header layer.
- PO_AGENTS — joined via AGENT_ID; buyer identity.
- PO_VENDORS — joined via VENDOR_ID.
- PO_VENDOR_SITES_ALL — joined via VENDOR_SITE_ID.
- PO_VENDOR_CONTACTS — joined via VENDOR_CONTACT_ID.
- FND_CURRENCIES — joined via CURRENCY_CODE.
- GL_DAILY_CONVERSION_TYPES — joined via RATE_TYPE.
- HR_ADE_STYLES — joined via STYLE_ID.
- ICX_PO_REVISIONS_TEMP — references this table via HEADER_ID and REVISION_NUM.
-
Archived purchase orders
-
View: PO_HEADERS_MERGE_V 12.2.2
APPS.PO_HEADERS_MERGE_V·↳ PO_DRAFTS·↳ PO_HEADERS_ALL·↳ PO_HEADERS_DRAFT_ALL·Explore PO module →
-
Draft Document headers (for purchase orders, purchase agreements, quotations, RFQs)
-
Interface table for purchase order headers
-
Document headers (for purchase orders, purchase agreements, quotations, RFQs)