Oracle Fusion · Data dictionary
PO_HEADERS_ALL
ProcurementUsed in 62 subject areas72 reporting columns
Purchasing (PO) — header table — one row per transaction or event (with detail in the paired _LINES table).
Likely primary key: PO_HEADER_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCEPTANCE_DUE_DATE | ● | Acceptance due date. | |
| ACCEPTANCE_REQUIRED_FLAG | ● | Indicator (Y/N) for the acceptance required. | |
| AGENT_ID | ● | Identifier for the agent. | |
| AGING_ONSET_POINT | ● | Aging onset point. | |
| AGING_PERIOD_DAYS | ● | Aging period days. | |
| ALT_CONTACT_EMAIL_ADDRESS | ● | Alt contact email address. | |
| AMOUNT_LIMIT | ● | Amount limit. | |
| AMOUNT_RELEASED | ● | Amount released. | |
| APPROVED_DATE | ● | Approved date. | |
| APPROVED_FLAG | ● | Indicator (Y/N) for the approved. | |
| BCC_EMAIL_ADDRESS | ● | Bcc email address. | |
| BILLING_CYCLE_CLOSING_DATE | ● | Billing cycle closing date. | |
| BLANKET_TOTAL_AMOUNT | ● | Blanket total amount. | |
| BUDGET_CONTROL_ENABLED_FLAG | ● | Indicator (Y/N) for the budget control enabled. | |
| BUYER_MANAGED_TRANSPORT_FLAG | ● | Indicator (Y/N) for the buyer managed transport. | |
| CC_EMAIL_ADDRESS | ● | Cc email address. | |
| CLOSED_DATE | ● | Closed date. | |
| COMMENTS | ● | Comments. | |
| CONFIRMING_ORDER_FLAG | ● | Indicator (Y/N) for the confirming order. | |
| CONSUMPTION_ADVICE_FREQUENCY | ● | Consumption advice frequency. | |
| CONSUMPTION_ADVICE_SUMMARY | ● | Consumption advice summary. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| DEFAULT_TAXATION_COUNTRY | ● | Default taxation country. | |
| DISABLE_AUTOSOURCING_FLAG | ● | Indicator (Y/N) for the disable autosourcing. | |
| DOCUMENT_CREATION_METHOD | ● | Document creation method. | |
| DOCUMENT_STATUS | ● | Status of the document. | |
| EMAIL_ADDRESS | ● | Email address. | |
| END_DATE | ● | End date. | |
| FOB_LOOKUP_CODE | ● | Lookup code for the fob. | |
| FREIGHT_TERMS_LOOKUP_CODE | ● | Lookup code for the freight terms. | |
| FROZEN_FLAG | ● | Indicator (Y/N) for the frozen. | |
| FUNDS_STATUS | ● | Status of the funds. | |
| GENERATE_ORDERS_AUTOMATIC | ● | Generate orders automatic. | |
| GROUP_REQUISITIONS | ● | Group requisitions. | |
| GROUP_REQUISITION_LINES | ● | Group requisition lines. | |
| INTERFACE_SOURCE_CODE | ● | Code identifying the interface source. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| MASTER_CONTRACT_ID | ● | Identifier for the master contract. | |
| MIN_RELEASE_AMOUNT | ● | Min release amount. | |
| MODE_OF_TRANSPORT | ● | Mode of transport. | |
| NOTE_TO_RECEIVER | ● | Note to receiver. | |
| NOTE_TO_VENDOR | ● | Note to vendor. | |
| ORCHESTRATION_ORDER_FLAG | ● | Indicator (Y/N) for the orchestration order. | |
| PAY_ON_CODE | ● | Code identifying the pay on. | |
| PAY_ON_USE_FLAG | ● | Indicator (Y/N) for the pay on use. | |
| PCARD_ID | ● | Identifier for the pcard. | |
| PO_HEADER_ID | PK? | ● | Identifier for the purchase order header. |
| PRC_BU_ID | ● | Identifier for the procurement business unit. | |
| RATE | ● | Rate. | |
| RATE_DATE | ● | Rate date. | |
| RATE_TYPE | ● | Type of rate. | |
| REFERENCE_NUM | ● | Reference number. | |
| RETRO_PRICE_APPLY_UPDATES_FLAG | ● | Indicator (Y/N) for the retro price apply updates. | |
| RETRO_PRICE_COMM_UPDATES_FLAG | ● | Indicator (Y/N) for the retro price comm updates. | |
| REVISED_DATE | ● | Revised date. | |
| REVISION_NUM | ● | Revision number. | |
| SEGMENT1 | ● | Segment1. | |
| SERVICE_LEVEL | ● | Service level. | |
| SKIP_ELECTRONIC_COMM_FLAG | ● | Indicator (Y/N) for the skip electronic comm. | |
| SOURCING_PRIORITY | ● | Sourcing priority. | |
| START_DATE | ● | Start date. | |
| SUBMIT_APPROVAL_AUTOMATIC | ● | Submit approval automatic. | |
| SUPPLIER_NOTIF_METHOD | ● | Supplier notif method. | |
| TYPE_LOOKUP_CODE | ● | Lookup code for the type. | |
| USE_NEED_BY_DATE | ● | Use need by date. | |
| USE_SALES_ORDER_NUMBER_FLAG | ● | Indicator (Y/N) for the use sales order number. | |
| USE_SHIP_TO | ● | Use shipment to. | |
| VENDOR_ID | ● | Identifier for the vendor. | |
| VENDOR_ORDER_NUM | ● | Vendor order number. | |
| VENDOR_SITE_ID | ● | Identifier for the vendor site. |
1 report read from this table
Change a column here and these are the reports that move with it — the blast radius for any change to PO_HEADERS_ALL.
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
- Budgetary Control - Transactions Real Time
- Costing - Cost Accounting Real Time
- Costing - Cost Rollup Details Real Time
- Costing - Landed Costs Real Time
- Costing - Receipt Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
- Costing - Where Used Details Real Time
- Costing - Work Order Costs Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Enterprise Contracts - Contracts Real Time
- Enterprise Quality Actions Real Time
- Enterprise Quality Issues Real Time
- Fiscal Document Capture Transactions Real Time
- Fiscal Document Holds Real Time
- Fiscal Document Item Deliveries Real Time
- Installed Base - Meter Based Asset Usage Real Time
- Inventory - Inventory Supply Real Time
- Inventory - Inventory Transactions Real Time
- Inventory - Inventory Transfer Order Real Time
- Inventory - Kanban Activity Real Time
Need the extract + dbt staging for PO_HEADERS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.