Search Results pon_item_prices_interface




Overview
Explore in AI Chat

Overview

PON_ITEM_PRICES_INTERFACE is a temporary (staging) table within the PON – Sourcing product of Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. It holds item price details that are imported from or exported to Microsoft Excel during sourcing and auction line maintenance. The table acts as a transient holding area between external spreadsheet data and the transactional sourcing tables, allowing buyers and sourcing managers to upload line-level pricing, quantities, and related attributes in bulk or to extract existing auction line data for offline review.

The object is owned by the PON schema and is documented with 107 physical columns. Under the heuristic Data Vault classification mined from its foreign key structure, the table is best modeled as a link, since it sits at the intersection of several business entities — auctions, projects, tasks, line types, and users — rather than functioning as a standalone descriptive satellite or a single-subject hub.

Key Information Stored

The documented columns reveal a staging structure that mirrors the attributes of auction lines and their pricing. The most significant columns include:

The surrogate key is INTERFACE_LINE_ID; business-key candidates are the combination of INTERFACE_HEADER_ID and AUCTION_LINE_NUMBER, which identifies a staged line within its auction context.

Common Use Cases and Queries

Typical usage centers on bulk import/export of auction pricing via the Sourcing spreadsheet integration. A buyer downloads auction lines into Excel, edits prices and quantities, and re-uploads; the interface table receives the inbound rows for validation and posting. Common queries include:

  • Reviewing pending staged lines for a specific auction: SELECT interface_line_id, auction_line_number, item_description, price FROM pon_item_prices_interface WHERE auction_header_id = :auction_id;
  • Detecting rows with errors before posting, by joining INTERFACE_LINE_ID and INTERFACE_HEADER_ID to the PON interface error tables and checking ACTION values.
  • Reconciling imported quantities and prices against the posted auction lines in PON_AUCTION_LINES_ALL after the interface run.
  • Reporting on project-funded lines by joining PROJECT_ID to PA_PROJECTS_ALL and PROJECT_TASK_ID to PA_TASKS.

Because the table is temporary by design, rows are transient and should be treated as in-flight data rather than a historical record; persistent values live in the PON auction line tables after successful processing.

Related Objects

The documented foreign keys identify the principal related objects and the join columns:

  • PON_AUCTION_HEADERS_ALL — via AUCTION_HEADER_ID; the parent auction for each staged line.
  • PO_LINE_TYPES_B — via LINE_TYPE_ID; supplies valid purchasing line types.
  • PA_PROJECTS_ALL — via PROJECT_ID; project funding reference.
  • PA_TASKS — via PROJECT_TASK_ID; project task reference.
  • FND_USER — via WORK_APPROVER_USER_ID; the approver identity.

In addition, the auction line and header tables within PON, along with the Sourcing spreadsheet import/export concurrent programs, depend on this interface table as the conduit between external spreadsheets and Oracle EBS transactional data.