Search Results process_spreadsheet_data




Overview
Explore in AI Chat

Overview

The APPS.PON_RESPONSE_IMPORT_PKG package is a PL/SQL program unit within the Oracle E-Business Suite Sourcing (Oracle Sourcing / Oracle iSupplier Portal) module. Its principal business function is to import supplier responses to sourcing events—typically bids, quotations, or auction responses—into the Sourcing transactional tables. Suppliers and buying organizations frequently prepare responses outside the application in spreadsheet or XML formats, and this package provides the server-side logic that ingests, validates, and persists that data as structured bid or auction response records. The package is classified as OTHER in the ETRM metadata, indicating that it is an internal implementation utility rather than a documented public API. It is part of the PON (Purchasing/Sourcing) application schema and resides in the APPS schema, which is standard for EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package body exposes six documented program units, whose names reflect the import lifecycle:

  • GET_MESSAGE_1_TOKEN — A helper that retrieves a message token, likely used to resolve or format user-facing error or status messages generated during import processing.
  • PROCESS_SPREADSHEET_DATA — The core routine that parses incoming spreadsheet (delimited) response data and stages it for validation and loading into the bid response interface structures.
  • PROCESS_XML_SPREADSHEET_DATA — The XML analog of the above, parsing response payloads supplied in XML spreadsheet format.
  • REMOVE_XML_SKIPPED_LINES — Cleanses the staging area by removing lines that were intentionally skipped during XML parsing, preventing stale or invalid rows from being processed.
  • COPY_SHIPMENT_INTERFACE_TO_TXN — Moves shipment-level response data from the interface table into the transactional shipment tables once validation succeeds.
  • PROCESS_SPREADSHEET_UDA_DATA — Handles import of user-defined attribute (UDA) values associated with supplier responses.

Tables Accessed

The package reads and writes several core Sourcing tables through APPS synonyms. Interface and transactional bid tables include PON_BID_HEADERS, PON_BID_ITEM_PRICES, PON_BID_ITEM_PRICES_INTERFACE, PON_BID_SHIPMENTS, and PON_INTERFACE_ERRORS, which together hold the response header, item pricing, shipment, and error-capture records. UDA data is handled via PO_UDA_INTERFACE. Auction-related structures—PON_AUCTION_HEADERS_ALL, PON_AUCTION_ITEM_PRICES_ALL, PON_AUCTION_SHIPMENTS_ALL, PON_AUCTION_ATTRIBUTES, and PON_AUC_BIZRULES—support auction response scenarios. Attachment and security references are resolved through FND_ATTACHED_DOCUMENTS, FND_DOCUMENT_CATEGORIES, and FND_USER.

Usage Notes

PON_RESPONSE_IMPORT_PKG is typically invoked indirectly by the Sourcing application rather than called directly by end users. It supports supplier response upload through the Sourcing UI and related concurrent programs that process spreadsheet or XML response files. Because the metadata documents that it is referenced by no other packages, it functions as a terminal utility within the response-import flow. Customizations that extend response import should treat the package as an internal component and avoid modifying it directly, since Oracle may change its internals between patch levels in 12.1.1 and 12.2.2.