PON — Sourcing
118 documented tables · 20 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
PON_AUCTION_HEADERS_ALL |
Stores the negotiations header level details. | hub |
PON_SIDEBAR_ITEMS |
Stores sidebar item data | satellite-leaning |
PON_AUCTION_ITEM_PRICES_ALL |
Stores the negotiation item details including price. | hub-leaning |
PON_BID_HEADERS |
Contains header level data for a response to a negotiation | hub-leaning |
PON_AUC_DOCTYPES |
Stores the negotiation document type | hub |
PON_SCORING_TEAMS |
This table stores information about scoring teams that may be created optionally for a negotiation. A scoring | hub-leaning |
PON_PRICE_ELEMENT_TYPES |
Stores price element type details | hub-leaning |
PON_AUCTION_TEMPLATES |
Stores the template information from which negotiations can be created | satellite-leaning |
PON_AUCTION_EVENTS |
Stores the event details of a group of negotiations. | satellite-leaning |
PON_ATTRIBUTE_LISTS |
Stores the attribute lists that belong to a trading partner. | satellite-leaning |
PON_OPTIMIZE_SCENARIOS |
This table stores information about the award optimization scenarios | hub-leaning |
PON_AUC_HEADERS_INTERFACE |
Interface table to store imported negotiation header information | satellite-leaning |
PON_BID_ITEM_PRICES |
Contains information regarding the responses submitted by a supplier on a negotiation. | satellite-leaning |
PON_THREAD_ENTRIES |
Stores message content for threaded discussions | satellite-leaning |
PON_AUC_BIZRULES |
Stores negotiations business rules | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
PON_NEG_COPY_DATATYPES_GRP |
GRP | 0 | 7 packages |
PON_COPY_UDAS_GRP |
GRP | 11 | 7 packages |
PON_CONTERMS_UTL_GRP |
GRP | 6 | 4 packages |
PON_CF_TYPE_GRP |
GRP | 4 | 4 packages |
PON_NEGOTIATION_COPY_GRP |
GRP | 9 | 3 packages |
PON_SOURCING_OPENAPI_GRP |
GRP | 12 | 1 packages |
PON_VENDOR_PURGE_GRP |
GRP | 2 | 1 packages |
PON_VENDORMERGE_GRP |
GRP | 1 | 1 packages |
PON_PO_INTEGRATION_GRP |
GRP | 2 | 1 packages |
PON_SOURCING_API_GRP |
GRP | 1 | 1 packages |