Results for “old_payment_display_number”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PON_BID_PAYMENTS_SHIPMENTS is a Sourcing (PON) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the payment details defined on a supplier response when the associated negotiation line involves complex services. In the Sourcing workflow, buyers author payment terms on the negotiation through the PON_AUC_PAYMENTS_SHIPMENTS table; when suppliers respond, those payment definitions are instantiated per bid so that each response carries its own payment schedule. PON_BID_PAYMENTS_SHIPMENTS is that response-side counterpart, with the AUCTION_PAYMENT_ID foreign key providing the explicit link back to the negotiation-level payment record.

The table is owned by the PON schema and exposes 26 documented columns. From a Data Vault modeling perspective, the FK structure mined from the metadata is satellite-leaning: the table is keyed by BID_PAYMENT_ID, is functionally dependent on a bid and auction context, and also carries OLD_* shadow columns that preserve prior payment values, which is characteristic of a descriptive satellite tracking change or award-time comparison rather than an independent business hub.

Key Information Stored

The surrogate primary key is BID_PAYMENT_ID, enforced by PON_BID_PAYMENTS_SHIPMENTS_PK and mirrored by the unique index PON_BID_PAYMENTS_SHIPMENTS_U1. The meaningful columns include:

• BID_PAYMENT_ID — Primary key and the column through which downstream purchasing tables reference the payment.
• BID_NUMBER — Identifies the supplier response (bid) on which the payment was defined; FK to PON_BID_HEADERS.
• BID_LINE_NUMBER — The response line to which the payment applies.
• AUCTION_HEADER_ID and AUCTION_LINE_NUMBER — The negotiation and negotiation line context; FKs to PON_AUCTION_HEADERS_ALL and PON_AUCTION_ITEM_PRICES_ALL.
• AUCTION_PAYMENT_ID — FK to PON_AUC_PAYMENTS_SHIPMENTS, tying the bid payment back to its negotiation-level definition.
• PAYMENT_DISPLAY_NUMBER — User-visible sequencing of the payment line.
• PAYMENT_DESCRIPTION, PAYMENT_TYPE_CODE — Descriptive text and the payment type classification.
• QUANTITY, UOM_CODE, PRICE, BID_CURRENCY_PRICE — The scheduled quantity, unit of measure, and pricing in both the negotiation and bid currencies.
• PROMISED_DATE — Scheduled date associated with the payment.
• OLD_PAYMENT_DISPLAY_NUMBER, OLD_PAYMENT_TYPE_CODE, OLD_PAYMENT_DESCRIPTION, OLD_QUANTITY, OLD_UOM_CODE, OLD_BID_CURRENCY_PRICE, OLD_PROMISED_DATE — Pre-change snapshots of the payment attributes, used to compare revised supplier terms against original values.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns.

Common Use Cases and Queries

Typical usage centers on reporting the payment schedule awarded from a negotiation and on tracing how supplier responses modified buyer-defined payment terms. A common query joins the table to PON_BID_HEADERS and PON_AUCTION_HEADERS_ALL to list payments per response:

• Extract the payment schedule for a negotiation: filter on AUCTION_HEADER_ID and order by BID_NUMBER, PAYMENT_DISPLAY_NUMBER.
• Detect supplier revisions: compare PAYMENT_TYPE_CODE, QUANTITY, PRICE, or PROMISED_DATE against the corresponding OLD_* columns.
• Reconcile response payments to negotiation definitions by joining on AUCTION_PAYMENT_ID to PON_AUC_PAYMENTS_SHIPMENTS.
• Trace downstream consumption by joining BID_PAYMENT_ID to PO_LINE_LOCATIONS_ALL for purchasing documents generated from the award.
• Diagnose interface or validation failures by joining BID_PAYMENT_ID to PON_INTERFACE_ERRORS.
• Identify open errors: check for BID_PAYMENT_ID values present in PON_INTERFACE_ERRORS.

Related Objects

• PON_AUCTION_HEADERS_ALL — Joined on AUCTION_HEADER_ID; supplies negotiation header context.
• PON_BID_HEADERS — Joined on BID_NUMBER; the parent supplier response record.
• PON_AUCTION_ITEM_PRICES_ALL — Joined on AUCTION_LINE_NUMBER and AUCTION_HEADER_ID; the negotiation line item prices.
• PON_AUC_PAYMENTS_SHIPMENTS — Joined on AUCTION_PAYMENT_ID; the negotiation-level payment definition that this row mirrors.
• PON_INTERFACE_ERRORS — References BID_PAYMENT_ID; holds validation errors tied to the payment row.
• PO_LINE_LOCATIONS_ALL — References BID_PAYMENT_ID; links awarded payments to purchasing document shipments.
• PO_LINE_LOCATIONS_ARCHIVE_ALL — Archived counterpart referencing BID_PAYMENT_ID for historical purchasing data.