Results for “wms_page_field_values”

33 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WMS_PAGE_FIELD_VALUES is a Warehouse Management (WMS) application table that stores the runtime values assigned to individual page fields rendered within the Oracle EBS WMS user interface framework. In Oracle Warehouse Management, pages are dynamically composed from page definitions and field definitions, and this table persists the concrete field property values associated with each page and field combination. It belongs to the WMS schema and is classified as VALID in both Oracle EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the mined relationship structure suggests a satellite-leaning classification. The table carries descriptive attribute values (FIELD_PROPERTY, FIELD_VALUE) that qualify a parent field definition held in WMS_PAGE_FIELDS_B, and the foreign key from FIELD_ID to WMS_PAGE_FIELDS_B reinforces this dependent, descriptive role rather than that of an independent hub or an associative link.

Key Information Stored

The table is documented with ten physical columns. The most significant columns fall into two groups: identifiers and audit attributes.

  • PAGE_ID — Identifies the WMS page to which the field value belongs. It participates in the unique business-key index rather than the primary key constraint.
  • FIELD_ID — The foreign key to WMS_PAGE_FIELDS_B, linking each row to its parent field definition. This is the anchor of the satellite relationship.
  • FIELD_PROPERTY — Names the property being valued (for example, display or configuration attributes of the field).
  • FIELD_VALUE — Holds the actual value assigned to that property for the given page and field.
  • ZD_EDITION_NAME — The editioning column supporting Oracle EBS 12.2 online patching, allowing multiple editions of the same logical row to coexist.
  • Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard EBS who/when auditing.

The surrogate primary key is WMS_PAGE_FIELD_VALUES_PK, composed of FIELD_ID, FIELD_PROPERTY, and FIELD_VALUE. The unique business-key candidate is WMS_PAGE_FIELD_VALUES_U1 over PAGE_ID, FIELD_ID, FIELD_PROPERTY, FIELD_VALUE, and ZD_EDITION_NAME, which guards against duplicate property values within an edition.

Common Use Cases and Queries

Typical uses include auditing how WMS pages are configured, diagnosing why a field displays an unexpected value, and migrating page field configuration between environments.

  • Retrieve all property values for a given field: SELECT FIELD_PROPERTY, FIELD_VALUE FROM WMS.WMS_PAGE_FIELD_VALUES WHERE FIELD_ID = :field_id;
  • List values for every field on a page: SELECT FIELD_ID, FIELD_PROPERTY, FIELD_VALUE FROM WMS.WMS_PAGE_FIELD_VALUES WHERE PAGE_ID = :page_id ORDER BY FIELD_ID;
  • Join to the field definition to obtain the owning field's descriptive attributes: SELECT b.*, v.FIELD_PROPERTY, v.FIELD_VALUE FROM WMS.WMS_PAGE_FIELDS_B b, WMS.WMS_PAGE_FIELD_VALUES v WHERE b.FIELD_ID = v.FIELD_ID;
  • In 12.2 environments, filter on ZD_EDITION_NAME to isolate the rows belonging to the currently active edition.

Because the table is relatively small and configuration-oriented, queries are typically low-volume and used in setup validation reports or troubleshooting scripts rather than high-throughput reporting.

Related Objects

The principal dependency is the parent field definition table.

  • WMS_PAGE_FIELDS_B — Referenced through WMS_PAGE_FIELD_VALUES.FIELD_ID; supplies the underlying field metadata that this table qualifies.
  • WMS_PAGE_FIELD_VALUES_PK / WMS_PAGE_FIELD_VALUES_U1 — The primary key constraint and unique index enforcing row uniqueness and edition consistency.
  • Page definition objects in the WMS schema — Tables holding page-level metadata (referenced via PAGE_ID) provide the containing page context for these field values.
  • WMS page rendering APIs and concurrent programs — Application logic that composes WMS pages reads this table to resolve field property values at runtime.

Because the documented FK surface is narrow, WMS_PAGE_FIELDS_B and the page-level definition objects are the dominant related structures. Any extension or interface working with WMS page configuration should treat WMS_PAGE_FIELD_VALUES as a dependent satellite keyed to WMS_PAGE_FIELDS_B through FIELD_ID.