Search Results oe_pc_vtmplt_cols




Overview
Explore in AI Chat

Overview

The OE_PC_VTMPLT_COLS table is a core data object within the Oracle E-Business Suite (EBS) Order Management (ONT) module. It serves as a child table to OE_PC_VTMPLTS, providing the detailed validation rules for a specific type of configuration template. Specifically, this table stores the attribute validation pairs for validation templates that are based on column values. These templates are integral to the Product Configurator, where they enforce business rules and ensure data integrity by validating user selections against predefined criteria during the configuration of complex products.

Key Information Stored

The table's primary function is to store the individual validation conditions that comprise a column-based validation template. While the full column list is not detailed in the provided metadata, the documented relationships and naming conventions reveal its critical structure. The primary key, VALIDATION_TMPLT_COL_ID, uniquely identifies each validation rule. The foreign key column, VALIDATION_TMPLT_ID, links each rule to its parent template defined in the OE_PC_VTMPLTS table. The remaining columns in the table would typically define the specific validation logic, such as the application column to be validated, the operator (e.g., =, >, IN), and the allowed or comparison value. This structure allows a single validation template to enforce multiple conditional rules on product attributes.

Common Use Cases and Queries

This table is primarily accessed for troubleshooting configuration validation errors, auditing business rules, and during template maintenance. A common query involves listing all validation rules for a specific template to understand its complete logic. For example:

  • Identifying all column validations for a template: SELECT * FROM ont.oe_pc_vtmplt_cols WHERE validation_tmplt_id = <TEMPLATE_ID> ORDER BY validation_tmplt_col_id;
  • Joining with the parent template table for a comprehensive view: SELECT tmplt.template_name, cols.* FROM ont.oe_pc_vtmplts tmplt, ont.oe_pc_vtmplt_cols cols WHERE tmplt.validation_tmplt_id = cols.validation_tmplt_id;

These queries are essential for support personnel diagnosing why a particular product configuration fails validation, as the rules stored here directly govern the permissible combinations of features and options.

Related Objects

OE_PC_VTMPLT_COLS has a direct and critical dependency on the OE_PC_VTMPLTS table, which stores the header-level definition of the validation template. The documented foreign key relationship is:

  • Foreign Key Reference: OE_PC_VTMPLT_COLS.VALIDATION_TMPLT_ID → OE_PC_VTMPLTS (Table). This ensures that every validation rule must be associated with a valid parent template. No validation rule can exist independently.

As a child table in this relationship, OE_PC_VTMPLT_COLS is central to the Product Configurator's validation engine. It is likely referenced by internal Oracle APIs and seed data scripts, but its primary interaction is through the parent OE_PC_VTMPLTS entity within the application's configuration logic.