Oracle Fusion · Data dictionary
PON_AUCTION_HEADERS_ALL
ProcurementUsed in 8 subject areas50 reporting columns
Sourcing / Negotiations (PON), header table, one row per transaction or event (with detail in the paired _LINES table).
Likely primary key: AUCTION_HEADER_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ALLOW_ALTERNATE_LINES | ● | Allow alternate lines. | |
| APPROVAL_AMOUNT | ● | Approval amount. | |
| AUCTION_HEADER_ID | PK? | ● | Identifier for the auction header. |
| AUCTION_HEADER_ID_ORIG_AMEND | ● | Auction header id orig amend. | |
| AUCTION_ROUND_NUMBER | ● | Auction round number. | |
| AUCTION_STATUS | ● | Status of the auction. | |
| AUCTION_TITLE | ● | Auction title. | |
| AWARD_BY_DATE | ● | Award by date. | |
| AWARD_COMPLETE_DATE | ● | Award complete date. | |
| AWARD_DATE | ● | Award date. | |
| AWARD_STATUS | ● | Status of the award. | |
| BID_FREQUENCY_CODE_DSP_FLAG | ● | Indicator (Y/N) for the bid frequency code dsp. | |
| BID_LIST_TYPE_DSP_FLAG | ● | Indicator (Y/N) for the bid list type dsp. | |
| BID_RANKING | ● | Bid ranking. | |
| BID_REVISION_TYPE | ● | Type of bid revision. | |
| BID_SCOPE_CODE_DSP_FLAG | ● | Indicator (Y/N) for the bid scope code dsp. | |
| BID_VISIBILITY_CODE | ● | Code identifying the bid visibility. | |
| BUYER_TRANSPORT_FLAG | ● | Indicator (Y/N) for the buyer transport. | |
| CLOSE_BIDDING_DATE | ● | Close bidding date. | |
| CONTRACT_TYPE | ● | Type of contract. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CREATION_DATE_ORIG_AMEND | ● | Creation date orig amend. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| DISPLAY_BEST_PRICE_DSP_FLAG | ● | Indicator (Y/N) for the display best price dsp. | |
| DOCTYPE_ID | ● | Identifier for the doctype. | |
| DOCUMENT_NUMBER | ● | Document number. | |
| HDR_ATTR_DISPLAY_SCORE | ● | Header attribute display score. | |
| HDR_ATTR_ENABLE_WEIGHTS | ● | Header attribute enable weights. | |
| MODE_OF_TRANSPORT | ● | Mode of transport. | |
| NUMBER_PRICE_DECIMALS | ● | Number price decimals. | |
| OPEN_AUCTION_NOW_FLAG | ● | Indicator (Y/N) for the open auction now. | |
| OPEN_BIDDING_DATE | ● | Open bidding date. | |
| PO_AGREED_AMOUNT | ● | Purchase order agreed amount. | |
| PO_END_DATE | ● | Purchase order end date. | |
| PO_MIN_REL_AMOUNT | ● | Purchase order min rel amount. | |
| PO_START_DATE | ● | Purchase order start date. | |
| PRICE_TIERS_INDICATOR | ● | Price tiers indicator. | |
| PUBLISH_DATE | ● | Publish date. | |
| PUBLISH_DATE_ORIG_AMEND | ● | Publish date orig amend. | |
| RANK_INDICATOR | ● | Rank indicator. | |
| SEALED_ACTUAL_UNLOCK_DATE | ● | Sealed actual unlock date. | |
| SEALED_AUCTION_STATUS | ● | Status of the sealed auction. | |
| SERVICE_LEVEL | ● | Service level. | |
| SOURCE_DOC_NUMBER | ● | Source doc number. | |
| STYLE_ID | ● | Identifier for the style. | |
| SYNOPSIS | ● | Synopsis. | |
| TECHNICAL_ACTUAL_UNLOCK_DATE | ● | Technical actual unlock date. | |
| TECHNICAL_LOCK_STATUS | ● | Status of the technical lock. | |
| TWO_PART_FLAG | ● | Indicator (Y/N) for the two part. | |
| VIEW_BY_DATE | ● | View by date. |
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
- Procurement - Procure To Pay Real Time
- Procurement - Requisitions Real Time
- Project Management - Project Work Items Real Time
- Sourcing - Program Real Time
- Sourcing - Supplier Awards Real Time
- Sourcing - Supplier Negotiations Real Time
- Sourcing - Supplier Responses Real Time
Need the extract + dbt staging for PON_AUCTION_HEADERS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table