Oracle Fusion · Data dictionary
PON_PROGRAM_HEADERS
ProcurementUsed in 1 subject areas13 reporting columns
Sourcing / Negotiations (PON) — header table — one row per transaction or event (with detail in the paired _LINES table).
Likely primary key: PROGRAM_HEADER_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| COMMENTS | ● | Comments. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| CURRENT_SPEND | ● | Current spend. | |
| END_DATE | ● | End date. | |
| GLOBAL_PROGRAM_FLAG | ● | Indicator (Y/N) for the global program. | |
| PROGRAM_HEADER_ID | PK? | ● | Identifier for the program header. |
| PURCHASING_CAT_FLAG | ● | Indicator (Y/N) for the purchasing cat. | |
| RATE_DATE | ● | Rate date. | |
| SAVINGS | ● | Savings. | |
| START_DATE | ● | Start date. | |
| SYNOPSIS | ● | Synopsis. | |
| TARGET_SPEND | ● | Target spend. | |
| TITLE | ● | Title. |
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.
Need the extract + dbt staging for PON_PROGRAM_HEADERS?
We ship parameterized SQL, BICC config, and dbt models you own.