Search Results pon_auction_sections




Overview
Explore in AI Chat

Overview

The PON_AUCTION_SECTIONS table is a core data object within the Oracle E-Business Suite (EBS) Sourcing (PON) module, specifically in versions 12.1.1 and 12.2.2. It functions as the master repository for defining distinct sections used to organize Requirements, also known as Header Attributes, within the sourcing process. These sections provide a structural framework for grouping related attributes on a negotiation or auction document, thereby enhancing data organization and user interface clarity for buyers and suppliers. Its role is foundational to the attribute management system in Sourcing, enabling the logical categorization of complex procurement requirements.

Key Information Stored

While the provided metadata does not list all columns, the documented primary and foreign keys reveal the essential data relationships. The primary identifier is the SECTION_ID, which uniquely defines each section record. A critical foreign key column is ATTRIBUTE_LIST_ID, which links each section to its corresponding attribute definition list stored in the PON_ATTRIBUTE_LISTS table. This relationship indicates that the table likely stores additional descriptive columns, such as a section name, display sequence (to control ordering on the UI), and potentially indicators for active status or section type, which govern how the section is presented and used within a negotiation.

Common Use Cases and Queries

This table is primarily accessed for configuration reporting and data validation. Common use cases include auditing the setup of requirement sections across the system, troubleshooting missing sections in a negotiation document, and generating master lists of available sections. A typical query would join to PON_ATTRIBUTE_LISTS to understand the full context of a section.

  • Sample Query: Retrieve all active sections with their associated attribute list name:
    SELECT pas.section_id, pas.section_name, pal.list_name FROM pon_auction_sections pas, pon_attribute_lists pal WHERE pas.attribute_list_id = pal.attribute_list_id AND pas.enabled_flag = 'Y' ORDER BY pas.display_sequence;
  • Reporting Use Case: Identifying which sections are configured but not currently assigned to any active auction template.

Related Objects

The PON_AUCTION_SECTIONS table maintains a direct and documented relationship with other key Sourcing tables, forming part of the attribute management hierarchy.

  • PON_ATTRIBUTE_LISTS (Foreign Key Relationship): This is the primary related object. The column PON_AUCTION_SECTIONS.ATTRIBUTE_LIST_ID is a foreign key referencing PON_ATTRIBUTE_LISTS. This link associates each section with a master list of attribute definitions that populate the section's content.
  • PON_AUCTION_ATTRIBUTES: While not listed in the provided metadata, this table typically stores the specific instance of attribute values for a given auction. It would logically relate to PON_AUCTION_SECTIONS via the SECTION_ID, indicating which section an attribute belongs to within a specific negotiation.
  • Table: PON_AUCTION_SECTIONS 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_AUCTION_SECTIONS,  object_name:PON_AUCTION_SECTIONS,  status:VALID,  product: PON - Sourcing ,  description: This table stores the distinct sections for Requirements (Header Attributes) ,  implementation_dba_data: PON.PON_AUCTION_SECTIONS , 

  • Table: PON_AUCTION_SECTIONS 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_AUCTION_SECTIONS,  object_name:PON_AUCTION_SECTIONS,  status:VALID,  product: PON - Sourcing ,  description: This table stores the distinct sections for Requirements (Header Attributes) ,  implementation_dba_data: PON.PON_AUCTION_SECTIONS , 

  • Table: PON_ATTRIBUTE_LISTS 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_ATTRIBUTE_LISTS,  object_name:PON_ATTRIBUTE_LISTS,  status:VALID,  product: PON - Sourcing ,  description: Stores the attribute lists that belong to a trading partner. ,  implementation_dba_data: PON.PON_ATTRIBUTE_LISTS , 

  • Table: PON_ATTRIBUTE_LISTS 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_ATTRIBUTE_LISTS,  object_name:PON_ATTRIBUTE_LISTS,  status:VALID,  product: PON - Sourcing ,  description: Stores the attribute lists that belong to a trading partner. ,  implementation_dba_data: PON.PON_ATTRIBUTE_LISTS ,