PON Tables (118)
PON - Sourcing — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
PON_ACCEPTANCES |
13 | Stores the acceptance of a respomses for an on-line negotiation of an item. |
PON_ACKNOWLEDGEMENTS |
13 | Holds the supplier user response of whether they acknowledged the changes in negotiation amendments. |
PON_ACTION_HISTORY |
13 | To store Approval History |
PON_ATTACHMENTS_INTERFACE |
9 | Interface table to store imported negotiation attachments |
PON_ATTRIBUTES_INTERFACE |
8 | Temporary table that contains the attribute details about the attributes that are transferred from BPA to a negotiation document. |
PON_ATTRIBUTE_LISTS |
13 | Stores the attribute lists that belong to a trading partner. |
PON_ATTRIBUTE_SCORES |
13 | stores the scoring criteria for a particular attribute |
PON_AUCTION_ATTRIBUTES |
38 | Stores negotiation item attributes. |
PON_AUCTION_ATTR_MAPPING_B |
18 | Supplier Management project. Mapping auction attributes to user-defined attributes. |
PON_AUCTION_CURRENCY_RATES |
17 | Stores the currency conversion rate between the negotiation currency and the response currency |
PON_AUCTION_EVENTS |
16 | Stores the event details of a group of negotiations. |
PON_AUCTION_HEADERS_ALL |
311 | Stores the negotiations header level details. |
PON_AUCTION_ITEM_PRICES_ALL |
157 | Stores the negotiation item details including price. |
PON_AUCTION_SECTIONS |
13 | This table stores the distinct sections for Requirements (Header Attributes) |
PON_AUCTION_SHIPMENTS_ALL |
21 | Stores the negotiation shipment details |
PON_AUCTION_SUMMARY |
13 | Temporary table used to generate summary data for an item involved in an auction to display in the auction summary page |
PON_AUCTION_TEMPLATES |
96 | Stores the template information from which negotiations can be created |
PON_AUC_ATTRIBUTES_INTERFACE |
28 | Temporary table that contains the attribute details that have been imported or exported to to excel. |
PON_AUC_BIZRULES |
10 | Stores negotiations business rules |
PON_AUC_BIZRULE_VALUES |
9 | Stores the value for the negotiation business rule |
PON_AUC_DOCTYPES |
14 | Stores the negotiation document type |
PON_AUC_DOCTYPES_TL |
9 | Stores the translated document type name |
PON_AUC_DOCTYPE_RULES |
14 | Stores the business rules is applicable to a negotiation document type |
PON_AUC_HEADERS_INTERFACE |
36 | Interface table to store imported negotiation header information |
PON_AUC_ITEMS_INTERFACE |
45 | Interface table to store imported negotiation item information |
PON_AUC_PAYMENTS_INTERFACE |
28 | Interface table to store imported information of the payments that are defined on a negotiation for complex services. |
PON_AUC_PAYMENTS_SHIPMENTS |
24 | This contains the details of the payments that are defined on a negotiation for complex services. |
PON_AUC_PRICE_DIFFER_INT |
16 | Temporary table that contains the price differential details that have been imported or exported to to excel. |
PON_AUC_PRICE_ELEMENTS_INT |
16 | Temporary table that contains the price element details that have been imported or exported to to excel. |
PON_AUC_SHIPMENTS_INTERFACE |
14 | Interface table to store imported negotiation shipment information |
PON_AWARD_ALLOCATIONS |
14 | Contains the allocation of each awarded response to the backing requisitions for a particular negotiation line. |
PON_AWARD_ITEMS_INTERFACE |
11 | Temporary table used to transfer data from spreadsheet to the negotiation award table. |
PON_BACKING_REQUISITIONS |
11 | This table stores information about all the backing requisitions ties to a negotiation item line |
PON_BIDDERS_LISTS |
13 | Stores the header level data of an invitation list |
PON_BIDDING_PARTIES |
44 | Stores the parties participating in a negotiation. |
PON_BID_ATTRIBUTE_VALUES |
27 | Stores the attributes value of a line item which is part of a response to a negotiation. |
PON_BID_ATTR_VALUES_INTERFACE |
16 | Temporary table that stores data of response attribute values uploaded from spreadsheet |
PON_BID_HEADERS |
119 | Contains header level data for a response to a negotiation |
PON_BID_HEADERS_ARCH |
68 | No longer used. |
PON_BID_HEADERS_INTERFACE |
17 | Temporary table that contains the Bid Header details that have been imported or exported to to excel. |
PON_BID_ITEM_PRICES |
138 | Contains information regarding the responses submitted by a supplier on a negotiation. |
PON_BID_ITEM_PRICES_INTERFACE |
29 | PON_BID_ITEMS_PROCES_INTERFACE temporarily stores response information. |
PON_BID_ITEM_REFERENCES |
11 | Contains information regarding the relation of Unsolcited Lines to Solicitation Lines done by a supplier. |
PON_BID_PAYMENTS_INTERFACE |
21 | Interface table to store imported information of the payments that are defined on a response to a negotiation for complex services. |
PON_BID_PAYMENTS_SHIPMENTS |
26 | This contains the details of the payments that are defined on a response with complex services. This corresponds to the PON_AUC_PAYMENTS_SH |
PON_BID_PRICE_DIFFERENTIALS |
18 | Response price differentials table |
PON_BID_PRICE_DIFFER_INT |
16 | Temporary table that contains the response price differential details that have been imported or exported to to excel. |
PON_BID_PRICE_ELEMENTS |
21 | Stores price element bid details included in an auction or RFQ. |
PON_BID_PRICE_ELEMENTS_INT |
15 | Interface table for price element |
PON_BID_REBATES |
9 | This table is used to store rebates for a particular bid |
PON_BID_SHIPMENTS |
37 | Contains the response details for an shipment in a negotiation |
PON_BID_SHIPMENTS_INT |
24 | Store tempory data for Price Breaks spreadsheet uploading. |
PON_COLORS |
11 | This contains the list of allowable colors which will be used in the Live Console graphs. The shapes and the associated image file names ar |
PON_CONTRACTS |
20 | Stores the contract information such as Terms and Conditions that the negotiation owner would like a participant to accept. |
PON_CONTRACTS_TL |
17 | Stores the contract information in each language |
PON_DISCUSSIONS |
12 | This is the driving table for discussions. |
PON_DOCTYPE_STYLES |
9 | This table stores whether a style is enabled for a document type. |
PON_EMD_CORPORATE |
10 | |
PON_EMD_FIN_PARAMETERS_ALL |
21 | |
PON_EMD_PAYMENT_TYPES_ALL |
18 | |
PON_EMD_PAYMENT_TYPES_TL |
17 | |
PON_EMD_TRANSACTIONS |
73 | |
PON_EVALUATION_TEAMS |
10 | Supplier Management project. RFI Evaluation Team table. |
PON_EVALUATION_TEAM_MEMBERS |
8 | Supplier Management project. Evaluation team members table. |
PON_EVALUATION_TEAM_SECTIONS |
8 | Supplier Management project. Evaluation team sections table. |
PON_FBO_POSTS |
14 | This will store history of notice posted to FedBizOpps |
PON_FIELDS |
16 | Stores information about a field. |
PON_FIELDS_TL |
12 | Stores translatable information about a field. |
PON_FORMS_INSTANCES |
11 | Stores the relationship between the form and the negotiation/event. |
PON_FORMS_SECTIONS |
21 | Store the header details for a form, section or abstract. |
PON_FORMS_SECTIONS_TL |
13 | Stores the language specific information for a form, section or abstract. |
PON_FORM_FIELD_VALUES |
363 | Stores the form data. |
PON_FORM_SECTION_COMPILED |
18 | Stored the "compiled form". |
PON_FORM_SECTION_FIELDS |
16 | Stores the relationships between a form, section or abstract and its components. |
PON_FPJ_DELETED_ATTRIBUTES |
6 | This table is used to store data from the attributes table that was deleted as part of the Minimun release upgrade |
PON_FPK_DELETED_PRICE_ELEMENTS |
6 | This table stores information about the deleted unit price elements in FPK. |
PON_INTERFACE_ERRORS |
42 | Contains any errors from interfaces to other applications |
PON_ITEM_PRICES_INTERFACE |
107 | Temporary table contains the item price details that have been imported or exported to to excel. |
PON_LARGE_NEG_PF_VALUES |
10 | This table stores the buyer price factor values for a given supplier for a large negotiation |
PON_MNG_EVAL_BID_SECTIONS |
9 | Supplier Management project. Table to track sections removed or added to evaluations after Manage Evaluation Teams. |
PON_MNG_EVAL_TEAM_MEMBERS |
9 | Supplier Management project. Table to track changes to team members after Manage Evaluation Teams. |
PON_MNG_EVAL_TEAM_SECTIONS |
10 | Supplier Management project. Table to track changes to team sections assignment after Manage Evaluation Teams. |
PON_NEGOTIATION_STYLES |
37 | This table stores negotiation style related information. |
PON_NEGOTIATION_STYLES_TL |
11 | This table stores language specific negotiation style information. |
PON_NEG_TEAM_MEMBERS |
18 | Stores Collaboration Team member details included in a negotiation or template. |
PON_NOTIF_GROUP_MEMBERS |
9 | This table stores the individual notifications assigned to a particular group. |
PON_NOTIF_SUBSCRIPTION_GROUPS |
14 | This table stores the notification subscription preferences for the sourcing instance. |
PON_OPTIMIZE_BID_CLASS |
8 | This table stores the suppliers for a particular constraint |
PON_OPTIMIZE_CONSTRAINTS |
56 | This table stores information about the user created constraints |
PON_OPTIMIZE_RESULTS |
12 | This table stores information about the results of award optimization scenarios |
PON_OPTIMIZE_SCENARIOS |
34 | This table stores information about the award optimization scenarios |
PON_ORCA_CERT_DETAILS |
19 | |
PON_PARTY_LINE_EXCLUSIONS |
11 | Table stores negotiation line restrictions for a particular supplier/line combination |
PON_PARTY_PREFERENCES |
10 | Stores data for a party preferences within an application |
PON_PF_SUPPLIER_FORMULA |
13 | This table stores aggregated price factor values for a given supplier. |
PON_PF_SUPPLIER_VALUES |
10 | This table stores auction costfactor values for invited suppliers. |
PON_PRICE_DIFFERENTIALS |
15 | Negotiation price differentials table |
PON_PRICE_DIFFER_INTERFACE |
12 | Interface table to store imported negotiation price differential information |
PON_PRICE_ELEMENTS |
19 | Stores price element details included in an auction or RFQ. |
PON_PRICE_ELEMENT_LISTS |
9 | Stores price element list details |
PON_PRICE_ELEMENT_TYPES |
16 | Stores price element type details |
PON_PRICE_ELEMENT_TYPES_TL |
11 | Stores price element type language details |
PON_SAAS_NEGOTIATION_PO |
5 | |
PON_SAAS_PO_ATTACHMENTS |
3 | |
PON_SCORING_TEAMS |
11 | This table stores information about scoring teams that may be created optionally for a negotiation. A scoring team is a group of collaborati |
PON_SCORING_TEAM_MEMBERS |
8 | PON_SCORING_TEAM_MEMBERS is a logical intersection entity between PON_NEG_TEAM_MEMBERS and PON_SCORING_TEAMS. It lists the members for each |
PON_SCORING_TEAM_SECTIONS |
8 | PON_SCORING_TEAM_SECTIONS records the team that has been assigned the responsibility of scoring each header attribute group for a negotiatio |
PON_SUPPLIER_ACCESS |
13 | This table will record the lock status for a supplier. As the negotiation proceeds the user might lock a supplier out of the negotiation f |
PON_SUPPLIER_ACTIVITIES |
14 | This table will contain a row for each distinct activity performed by a Supplier User on the Negotiation as he/she navigates through the bid |
PON_SUPPLIER_PROVIDERS |
8 | PON_SUPPLIER_PROVIDERS stores details of supplier providers. |
PON_TEAM_MEMBER_ATTR_SCORES |
12 | This table records scores for every scoring team member for a given attribute and a response. |
PON_TEAM_MEMBER_BID_SCORES |
11 | For negotiations enabled for team scoring, this table stores the evaluation for the responses on this negotiation for each team member. The |
PON_TE_RECIPIENTS |
8 | This table lists the recipient of the message. |
PON_TE_VIEW_AUDIT |
3 | A simple table keeping track of who viewed which message when. |
PON_THREADS |
6 | This identifies simple metadata for the thread. |
PON_THREAD_ENTRIES |
16 | Stores message content for threaded discussions |
PON_UMBRELLA_PROGRAMS |
31 | |
PON_WF_DEBUG |
9 | Holds the debug statements for workflow processes |