Oracle Fusion · Data dictionary
PO_HEADERS_DRAFT_ALL
ProcurementUsed in 12 subject areas24 reporting columns
Purchasing (PO), transaction table (rows scoped across all operating units).
Likely primary key: PO_HEADER_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): AGENT_ID → PO_AGENTS_V · PO_HEADER_ID → PO_HEADERS_ALL · VENDOR_SITE_ID → POZ_SUPPLIER_SITES_ALL_M
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCEPTANCE_REQUIRED_FLAG | ● | Indicator (Y/N) for the acceptance required. | |
| AGENT_ID | ● | Identifier for the agent. | |
| AMOUNT_LIMIT | ● | Amount limit. | |
| 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. | |
| COMMENTS | ● | Comments. | |
| CONFIRMING_ORDER_FLAG | ● | Indicator (Y/N) for the confirming order. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| DEFAULT_TAXATION_COUNTRY | ● | Default taxation country. | |
| END_DATE | ● | End date. | |
| FUNDS_STATUS | ● | Status of the funds. | |
| MIN_RELEASE_AMOUNT | ● | Min release amount. | |
| MODE_OF_TRANSPORT | ● | Mode of transport. | |
| NOTE_TO_RECEIVER | ● | Note to receiver. | |
| NOTE_TO_VENDOR | ● | Note to vendor. | |
| PO_HEADER_ID | PK? | ● | Identifier for the purchase order header. |
| SEGMENT1 | ● | Segment1. | |
| SERVICE_LEVEL | ● | Service level. | |
| START_DATE | ● | Start date. | |
| SUPPLIER_NOTIF_METHOD | ● | Supplier notif method. | |
| TYPE_LOOKUP_CODE | ● | Lookup code for the type. | |
| VENDOR_ID | ● | Identifier for the vendor. | |
| VENDOR_SITE_ID | ● | Identifier for the vendor site. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
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
- Maintenance Management - Purchased Item Usage Real Time
- Manufacturing - Purchased Item Usage Real Time
- Procurement - Pending Change Orders Real Time
- Procurement - Procure To Pay Real Time
- Procurement - Purchasing Agreements Real Time
- Procurement - Purchasing Real Time
- Procurement - Requisitions Real Time
- Procurement - Spend Real Time
- Sourcing - Supplier Awards Real Time
- Sourcing - Supplier Negotiations Real Time
- Sourcing - Supplier Responses Real Time
Need the extract + dbt staging for PO_HEADERS_DRAFT_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table