Search Results pon_auc_payments_shipments




Overview
Explore in AI Chat

Overview

The PON_AUC_PAYMENTS_SHIPMENTS table is a core data structure within the Oracle E-Business Suite Sourcing (PON) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for payment terms and shipment schedules defined on a sourcing negotiation (auction) for complex services. This table is fundamental to the procurement process for services, enabling buyers to define detailed, milestone-based payment schedules linked to project deliverables, work approval, and specific shipment or service fulfillment locations. Its data directly influences downstream processes, including supplier bidding on payment terms and the eventual creation of purchase order shipments.

Key Information Stored

The table's primary key is PAYMENT_ID, which uniquely identifies each payment schedule line. Critical foreign key columns establish its integration within the Sourcing and broader EBS landscape. AUCTION_HEADER_ID and LINE_NUMBER link the payment to a specific negotiation header and item line, respectively. For project-related services, PROJECT_ID and PROJECT_TASK_ID integrate with Oracle Projects. The table also stores logistical and approval details, including SHIP_TO_LOCATION_ID for defining the service delivery point and WORK_APPROVER_USER_ID to designate the individual responsible for approving work completion before a payment milestone is triggered. Other columns typically define payment attributes such as payment type, amount or percentage, sequence, and associated description.

Common Use Cases and Queries

Primary use cases involve reporting on negotiated payment terms and troubleshooting integration issues. A common reporting requirement is to extract all payment schedules for a given negotiation to analyze supplier cost structures. For example:

  • SELECT payment_id, line_number, payment_type, amount FROM pon_auc_payments_shipments WHERE auction_header_id = :p_auction_id ORDER BY line_number, payment_id;

Another critical scenario involves diagnosing errors during the import of supplier bid payments, where the PON_INTERFACE_ERRORS table references this table's PAYMENT_ID. A support query might join these tables to identify invalid payment data submitted by suppliers against the auction's defined payment schedule.

Related Objects

The table maintains extensive relationships with other EBS entities, as documented by its foreign keys. It is a child of the negotiation header and item tables:

For project accounting and services procurement, it integrates with:

For location and approval data:

It is a parent table to key transactional tables: