Search Results oe_pc_rset_sel_cols




Overview
Explore in AI Chat

Overview

The OE_PC_RSET_SEL_COLS table is a core data object within the Oracle E-Business Suite (EBS) Order Management (ONT) module, specifically for versions 12.1.1 and 12.2.2. It functions as a child table in the configuration of Pricing Constraints, a feature used to enforce complex business rules during order entry. Its primary role is to define the specific column criteria used to identify matching records within a constraint record set. Essentially, it stores the "where clause" conditions that determine which rows from a related record set table are applicable for a given pricing constraint, enabling precise control over when pricing rules are activated based on transactional data.

Key Information Stored

The table's structure is designed to map selection criteria to a parent record set. The critical columns, as defined by its primary key, are RECORD_SET_ID and COLUMN_NAME. The RECORD_SET_ID is a foreign key that links directly to the OE_PC_RSETS table, identifying the parent constraint record set. The COLUMN_NAME stores the name of the database column from the associated record set's base table that must be matched. While the provided metadata does not list all columns, typical implementations would also include a COLUMN_VALUE or similar column to store the specific value to match against, and potentially an OPERATOR column (e.g., '=', '>', 'IN'). The combination of these fields for a given RECORD_SET_ID defines the complete selection criteria for the constraint.

Common Use Cases and Queries

The primary use case is the administration and troubleshooting of pricing constraints. For instance, an analyst may need to audit all column criteria defined for a specific constraint record set. A common query would join this table to OE_PC_RSETS to list all matching criteria. Sample SQL to retrieve this information would be:

  • SELECT rset.record_set_name, selcol.column_name FROM ont.oe_pc_rset_sel_cols selcol JOIN ont.oe_pc_rsets rset ON selcol.record_set_id = rset.record_set_id WHERE rset.record_set_id = :p_record_set_id;

This data is crucial for debugging scenarios where a pricing constraint is not firing as expected; the issue may stem from an incorrectly defined column match in this table. The table is typically maintained via the Oracle Pricing Administrator forms, not via direct SQL manipulation.

Related Objects

OE_PC_RSET_SEL_COLS has a direct and documented foreign key relationship with the OE_PC_RSETS table, which is central to the pricing constraints framework. The relationship is defined as follows:

  • Foreign Key Table: OE_PC_RSET_SEL_COLS
  • Foreign Key Column: RECORD_SET_ID
  • Referenced/Primary Key Table: OE_PC_RSETS

This relationship ensures that every column selection criterion is associated with a valid, existing constraint record set. The OE_PC_RSETS table itself is linked to higher-level constraint definitions, ultimately tying the logic stored in OE_PC_RSET_SEL_COLS to specific pricing attributes and rules within the Order Management and Advanced Pricing modules.

  • Table: OE_PC_RSET_SEL_COLS 12.1.1

    owner:ONT,  object_type:TABLE,  fnd_design_data:ONT.OE_PC_RSET_SEL_COLS,  object_name:OE_PC_RSET_SEL_COLS,  status:VALID,  product: ONT - Order Management ,  description: This table stores columns to be matched for a constraint record set. ,  implementation_dba_data: ONT.OE_PC_RSET_SEL_COLS , 

  • Table: OE_PC_RSET_SEL_COLS 12.2.2

    owner:ONT,  object_type:TABLE,  fnd_design_data:ONT.OE_PC_RSET_SEL_COLS,  object_name:OE_PC_RSET_SEL_COLS,  status:VALID,  product: ONT - Order Management ,  description: This table stores columns to be matched for a constraint record set. ,  implementation_dba_data: ONT.OE_PC_RSET_SEL_COLS , 

  • Table: OE_PC_RSETS 12.2.2

    owner:ONT,  object_type:TABLE,  fnd_design_data:ONT.OE_PC_RSETS,  object_name:OE_PC_RSETS,  status:VALID,  product: ONT - Order Management ,  description: This table store the constraint record sets and the constraint conditions can be built to validate against any or all the records in this record set. ,  implementation_dba_data: ONT.OE_PC_RSETS , 

  • View: OE_PC_RSET_SEL_COLS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:ONT.OE_PC_RSET_SEL_COLS_V,  object_name:OE_PC_RSET_SEL_COLS_V,  status:VALID,  product: ONT - Order Management ,  description: This view stores the columns to be matched for the record set. ,  implementation_dba_data: APPS.OE_PC_RSET_SEL_COLS_V , 

  • Table: OE_PC_RSETS 12.1.1

    owner:ONT,  object_type:TABLE,  fnd_design_data:ONT.OE_PC_RSETS,  object_name:OE_PC_RSETS,  status:VALID,  product: ONT - Order Management ,  description: This table store the constraint record sets and the constraint conditions can be built to validate against any or all the records in this record set. ,  implementation_dba_data: ONT.OE_PC_RSETS , 

  • View: OE_PC_RSET_SEL_COLS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:ONT.OE_PC_RSET_SEL_COLS_V,  object_name:OE_PC_RSET_SEL_COLS_V,  status:VALID,  product: ONT - Order Management ,  description: This view stores the columns to be matched for the record set. ,  implementation_dba_data: APPS.OE_PC_RSET_SEL_COLS_V ,