Search Results value_string

Overview

OE_PC_VTMPLT_COLS_V is a validation view owned by the APPS schema in Oracle E-Business Suite, defined within the Order Management (ONT) product family. It exposes the individual column definitions that make up a processing constraint validation template. In Oracle Order Management, processing constraints control which order transactions are permitted or blocked based on conditions such as order type, line type, customer, or shipment status. Each constraint is backed by a validation template, and each template is composed of one or more column/operator/value combinations. This view presents those per-column definitions in a denormalized, human-readable form suitable for reporting, diagnostics, and integration.

The view joins the column definition rows against Oracle's attribute metadata (AK_OBJECT_ATTRIBUTES_VL) so that the technical column name is accompanied by the descriptive attribute label and the underlying data type. This makes the view directly usable for administrative reporting without requiring knowledge of the internal entity-to-attribute mapping maintained by the Application Object Library.

The status of the object is VALID in the 12.1.1 and 12.2.2 environments documented by ETRM, confirming it is a supported and queryable database object.

Underlying Base Objects

The view is defined over four referenced objects, consistent across 12.1.1 and 12.2.2:

• OE_PC_VTMPLT_COLS — the primary base (synonym resolved to the APPS table) that stores each validation template column row, including the operator and value string.
• OE_PC_VTMPLTS — the header of the validation template, providing the template identity and the entity it validates.
• OE_AK_OBJECTS_EXT — an extension of the AK entity registration that links a validation entity to the application and database object whose attributes are being validated.
• AK_OBJECT_ATTRIBUTES_VL — the translatable attribute view supplying ATTRIBUTE_LABEL_LONG, DATA_TYPE and the underlying column metadata.

The join logic chains these together: VTC.VALIDATION_TMPLT_ID = V.VALIDATION_TMPLT_ID, V.ENTITY_ID = E.ENTITY_ID, and then E.APPLICATION_ID / E.DATABASE_OBJECT_NAME / column name matched against AK.ATTRIBUTE_APPLICATION_ID, AK.DATABASE_OBJECT_NAME and AK.COLUMN_NAME. The ROWID of OE_PC_VTMPLT_COLS is surfaced as ROW_ID.

Key Columns

• ROW_ID — the physical row identifier of the source validation template column row.
• VALIDATION_TMPLT_COL_ID — primary key of the column definition; uniquely identifies a single condition within a template.
• VALIDATION_TMPLT_ID — foreign key to the parent validation template.
• COLUMN_NAME — the validated attribute (for example an order header or line column).
• COLUMN_DISPLAY_NAME — the user-facing attribute label sourced from AK_OBJECT_ATTRIBUTES_VL (ATTRIBUTE_LABEL_LONG).
• DATA_TYPE — the datatype of the validated column, used to interpret the comparison value correctly.
• VALIDATION_OP — the comparison operator applied (equals, not equals, in, greater than, and so on).
• VALUE_STRING — the literal or list of values the operator is applied against. This is the column most commonly searched for, as it reveals the specific value a processing constraint tests.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include tracing why a particular constraint blocks a transaction, identifying every constraint that references a specific value, and reporting the full clause set of a template.

To locate a template condition by value:

• SELECT vt.validation_tmplt_id, vtc.column_name, vtc.column_display_name, vtc.validation_op, vtc.value_string FROM oe_pc_vtmplt_cols_v vtc, oe_pc_vtmplts vt WHERE vtc.validation_tmplt_id = vt.validation_tmplt_id AND vtc.value_string = '&value_string';

To list all columns for a given template with labels and datatypes:

• SELECT column_display_name, column_name, data_type, validation_op, value_string FROM oe_pc_vtmplt_cols_v WHERE validation_tmplt_id = :template_id ORDER BY validation_tmplt_col_id;

To search by operator type across all templates:

• SELECT validation_tmplt_id, column_name, validation_op, value_string FROM oe_pc_vtmplt_cols_v WHERE validation_op = :op;

Because the view already resolves attribute labels, these queries are suitable for direct use in concurrent programs, BI Publisher data templates, and order management diagnostic scripts without additional AK metadata joins.