Oracle Fusion · Data dictionary
PON_BID_HEADERS
ProcurementUsed in 2 subject areas26 reporting columns
Sourcing / Negotiations (PON), header table, one row per transaction or event (with detail in the paired _LINES table).
Likely primary key: BID_HEADER_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AWARD_STATUS | ● | Status of the award. | |
| BID_CURRENCY_CODE | ● | Currency code for the bid. | |
| BID_HEADER_ID | PK? | ○ | Identifier for the bid header. |
| BID_NUMBER | ● | Bid number. | |
| BID_STATUS | ● | Status of the bid. | |
| CANCELLED_DATE | ● | Cancelled date. | |
| CANCEL_REASON | ● | Cancel reason. | |
| CREATED_BY | ● | User who created the row. | |
| DRAFT_LOCKED | ● | Draft locked. | |
| DRAFT_LOCKED_DATE | ● | Draft locked date. | |
| DRAFT_UNLOCKED_DATE | ● | Draft unlocked date. | |
| INTERNAL_NOTE | ● | Internal note. | |
| NOTE_TO_AUCTION_OWNER | ● | Note to auction owner. | |
| NOTE_TO_SUPPLIER | ● | Note to supplier. | |
| NUMBER_PRICE_DECIMALS | ● | Number price decimals. | |
| ORIGINAL_BID_NUMBER | ● | Original bid number. | |
| PARTIAL_RESPONSE_FLAG | ● | Indicator (Y/N) for the partial response. | |
| PUBLISH_DATE | ● | Publish date. | |
| RATE | ● | Rate. | |
| SHORTLIST_FLAG | ● | Indicator (Y/N) for the shortlist. | |
| SURROG_BID_FLAG | ● | Indicator (Y/N) for the surrog bid. | |
| SURROG_BID_ONLINE_ENTRY_DATE | ● | Surrog bid online entry date. | |
| SURROG_BID_RECEIPT_DATE | ● | Surrog bid receipt date. | |
| SURROG_METHOD_OF_RESPONSE | ● | Surrog method of response. | |
| TECHNICAL_SHORTLIST_FLAG | ● | Indicator (Y/N) for the technical shortlist. | |
| TRADING_PARTNER_ID | ● | Identifier for the trading partner. | |
| TYPE_OF_RESPONSE | ● | Type of response. |
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_BID_HEADERS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table