Search Results open_bidding_date




Overview
Explore in AI Chat

Overview

APPS.PON_AUCTION_HEADERS_V is a reporting and integration view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that exposes auction header information managed by Oracle Sourcing (part of the Advanced Procurement / ETRM family). The view presents one row per sourcing auction, consolidating commercial, scheduling, currency, and status attributes into a single denormalized structure suitable for inquiry screens, concurrent reports, Oracle Business Intelligence extracts, and third-party integrations. Its most prominent behavior is a runtime calculation: the CLOSE_BIDDING_DATE column is not simply stored data but is derived at query time to account for auctions that have been paused.

Underlying Base Objects

The view is defined over the following documented base objects:

  • PON_AUCTION_HEADERS (SYNONYM) — the primary transactional table holding auction header data; nearly every projected column originates here.
  • FND_LOOKUP_VALUES (SYNONYM) — the Oracle Application Object Library lookup repository, used to resolve coded values such as AUCTION_STATUS_NAME and AWARD_STATUS_NAME from their stored lookup codes.
  • HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM) — the translated organization units table, joined to supply operating unit or organization context.
  • HZ_PARTIES (SYNONYM) — the Trading Community Architecture party table, joined to resolve trading partner (supplier) identity and contact information.
  • PON_LOCALE_PKG (PACKAGE) — the Sourcing locale package, invoked to support language-sensitive formatting and localization of auction data.

The view therefore functions as a business-facing layer over the raw PON_AUCTION_HEADERS row, enriching it with resolved lookup meanings, supplier party details, and organization context while preserving the auction header identifier as the driving key.

Key Columns

Common Use Cases and Queries

Typical uses include auction open/close scheduling dashboards, pause-adjusted close-time reporting, supplier participation extracts, and XML/interface feeds to external bidding platforms.

To locate auctions by opening date:

  • SELECT auction_header_id, auction_title, open_bidding_date, close_bidding_date, auction_status_name FROM apps.pon_auction_headers_v WHERE open_bidding_date >= TRUNC(SYSDATE) ORDER BY open_bidding_date;

To list active auctions with their live (pause-adjusted) close times:

  • SELECT auction_title, trading_partner_name, open_bidding_date, close_bidding_date FROM apps.pon_auction_headers_v WHERE auction_status = 'ACTIVE' AND close_bidding_date > SYSDATE;

Because CLOSE_BIDDING_DATE is computed with SYSDATE, queries must not assume the column is a static stored value; any predicate on it is evaluated against the pause-adjusted derivation.