Results for “po_headers_draft_all”

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

Overview

PO_HEADERS_DRAFT_ALL (owner PO) is the Oracle Purchasing table that stores draft document headers for purchase orders, purchase agreements, quotations, and RFQs. It exists because Oracle E-Business Suite separates the working copy of a procurement document from its approved version. When a buyer initiates or modifies a purchasing document, the change is staged as a draft header row in this table; only upon approval does the draft flow into the corresponding header in PO_HEADERS_ALL. This staging model enables features such as Change Orders, the document approval workflow via Oracle Approvals Management (AME), and controlled revision history.

The table is date-effective throughout: it carries a DRAFT_ID discriminator rather than updating rows in place, so multiple draft versions can coexist for the same document. Under a heuristic Data Vault classification of the documented foreign-key structure, PO_HEADERS_DRAFT_ALL is best described as a link-type modeling candidate: it sits at the intersection of a source document (FROM_HEADER_ID → PO_HEADERS_ALL), a draft envelope (DRAFT_ID → PO_DRAFTS), a supplier, a location, and an agent, capturing the relationships that define a single draft revision.

Key Information Stored

The table contains 202 columns, of which the following are most significant for development and reporting:

• PO_HEADER_ID – the document identifier inherited from the source header. Together with DRAFT_ID it forms the surrogate primary key PO_HEADERS_DRAFT_PK.
• DRAFT_ID – foreign key to PO_DRAFTS; identifies the specific draft version to which the header row belongs.
• SEGMENT1 – the human-readable document number. It is a business-key candidate, appearing in unique index PO_HEADERS_DRAFT_U2 with TYPE_LOOKUP_CODE, ORG_ID, and DRAFT_ID.
• TYPE_LOOKUP_CODE – the document type (PO, blanket, contract, quotation, RFQ).
• ORG_ID – the operating unit that owns the document; central to Multi-Org access control.
• FROM_HEADER_ID / FROM_TYPE_LOOKUP_CODE – the released document a draft is derived from, used for change order tracking.
• AGENT_ID – foreign key to PO_AGENTS, identifying the buyer.
• VENDOR_ID, VENDOR_SITE_ID, VENDOR_CONTACT_ID – the supplier and its contact details.
• SHIP_TO_LOCATION_ID / BILL_TO_LOCATION_ID – foreign keys to HR_LOCATIONS_ALL.
• CURRENCY_CODE (→ FND_CURRENCIES) and RATE_TYPE (→ GL_DAILY_CONVERSION_TYPES) with RATE_DATE and RATE – pricing and conversion context.
• START_DATE_ACTIVE / END_DATE_ACTIVE – effective dating for agreements and blankets.
• AUTHORIZATION_STATUS, APPROVED_FLAG, APPROVED_DATE, CHANGE_STATUS, CHANGE_ACCEPTED_FLAG – approval workflow state indicators.
• SEGMENT2 through SEGMENT5, ATTRIBUTE1–15, and GLOBAL_ATTRIBUTE1–20 – descriptive flexfield and context columns.
• UMBRELLA_PROGRAM_ID – foreign key to PON_UMBRELLA_PROGRAMS for program-level reporting.

Common Use Cases and Queries

Typical usage centers on draft inspection, change order validation, and reporting on documents waiting for approval.

A change order belongs to the same document and draft combination; joining to PO_DRAFTS and PO_HEADERS_ALL confirms the base document and its status.

The most common reporting patterns include:

• Listing all drafts awaiting approval for a given operating unit.
• Identifying change orders on a controlled document by matching FROM_HEADER_ID back to PO_HEADERS_ALL.PO_HEADER_ID.
• Auditing revised blanket amounts by comparing BLANKET_TOTAL_AMOUNT between the draft and the released header.
• Extracting flexfield attribute values for supplier classification or cost-center analysis.

A representative query joins PO_HEADERS_DRAFT_ALL to PO_DRAFTS and PO_HEADERS_ALL on PO_HEADER_ID to surface pending change orders, filtering on CHANGE_STATUS and ORG_ID. Standard DBA practice when troubleshooting approval errors is to confirm that a row exists here for the DRAFT_ID referenced in the workflow tables.

Related Objects

• PO_DRAFTS – parent of the draft envelope; joined via PO_HEADERS_DRAFT_ALL.DRAFT_ID.
• PO_HEADERS_ALL – the released document header; joined via FROM_HEADER_ID and matching PO_HEADER_ID.
• PO_AGENTS – buyer definition; joined via AGENT_ID.
• HR_LOCATIONS_ALL – ship-to and bill-to addresses; joined via SHIP_TO_LOCATION_ID and BILL_TO_LOCATION_ID.
• FND_CURRENCIES – currency descriptions; joined via CURRENCY_CODE.
• GL_DAILY_CONVERSION_TYPES – conversion type names; joined via RATE_TYPE.
• PON_UMBRELLA_PROGRAMS – program definitions; joined via UMBRELLA_PROGRAM_ID.
• PO_LINES_DRAFT_ALL and the draft distributions tables – line and distribution details that accompany each draft header.
• AME_APPROVAL tables (via AME_APPROVAL_ID) – approval instance linkage for the document lifecycle.