Results for “wms_page_fields_b”

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

Overview

WMS_PAGE_FIELDS_B is the base configuration table for Oracle Warehouse Management (WMS) mobile page fields. It defines the individual data-entry and display elements that compose the mobile pages presented to warehouse operators on RF (radio frequency) handheld devices. In Oracle E-Business Suite 12.1.1 and 12.2.2, this table is owned by the WMS schema and its status is VALID. Each row represents a single configurable field within a mobile page, capturing the field's prompt, data type, display order, category, visibility, and default-value properties. Because the table is the "_B" (base) variant of a table pair, it stores language-independent attributes, while translated text such as prompts and descriptions resides in the corresponding WMS_PAGE_FIELDS_TL table.

From a dimensional modeling perspective, the mined foreign-key structure suggests a hub-leaning classification. WMS_PAGE_FIELDS_B behaves as a hub entity: FIELD_ID is a stable, uniquely identified business key, and the table is referenced by several dependent satellites and related tables. This is a heuristic suggestion rather than a mandated design, but it is useful when planning data-vault-style extractions or integration layers.

Key Information Stored

The table contains 18 documented columns. The most significant are:

• FIELD_ID — The surrogate primary key (WMS_PAGE_FIELDS_B_PK) that uniquely identifies each mobile page field. It is also the join key to all dependent tables.
• PAGE_ID — Identifies the parent mobile page to which the field belongs, linking field configuration to page structure.
• FIELD_NAME — The internal, language-independent name of the field, used by WMS code to reference the field.
• FIELD_PROMPT — The base prompt text displayed for the field (translatable variants live in WMS_PAGE_FIELDS_TL).
• FIELD_TYPE — The data type or control type of the field, determining input and validation behavior.
• FIELD_CONSTRUCTOR_PARAM — Parameters passed to the field constructor, controlling runtime behavior.
• FIELD_CATEGORY — Classifies the field for grouping and functional purposes.
• FIELD_DISP_SEQUENCE_NUMBER — Governs the order in which the field appears on the mobile page.
• FIELD_IS_CONFIGURABLE — Indicates whether the field may be reconfigured by administrators.
• FIELD_IS_VISIBLE — Determines whether the field is displayed on the page.
• FIELD_PROPERTY1_DEFAULT_VALUE and FIELD_PROPERTY2_DEFAULT_VALUE — Default values applied to the field's configurable properties.
• ZD_EDITION_NAME — The editioning column introduced for online patching in EBS 12.2, enabling edition-based redefinition.
• CREATION_DATE / CREATED_BY / LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — Standard audit columns tracking who created and last modified the row.

Two unique indexes identify business-key candidates: WMS_PAGE_FIELDS_B_U1 (FIELD_ID, ZD_EDITION_NAME) and WMS_PAGE_FIELDS_B_U2 (PAGE_ID, FIELD_NAME, ZD_EDITION_NAME). The latter enforces uniqueness of field names within a page.

Common Use Cases and Queries

Typical uses include reporting on the layout and configuration of mobile pages, auditing which fields are visible or configurable, and troubleshooting field behavior by inspecting prompts and types. A common query returns all fields for a given page in display order:

SELECT f.field_id, f.field_name, f.field_prompt, f.field_type, f.field_disp_sequence_number, f.field_is_visible FROM wms_page_fields_b f WHERE f.page_id = :page_id ORDER BY f.field_disp_sequence_number;

To retrieve translated prompts, join to WMS_PAGE_FIELDS_TL on FIELD_ID and select the desired language. To find fields with default values configured, filter on the FIELD_PROPERTY*_DEFAULT_VALUE columns. In 12.2 environments, queries should account for ZD_EDITION_NAME to ensure correct edition context.

Related Objects

• WMS_PAGE_FIELDS_TL — Stores translated prompt and description text; joined on FIELD_ID.
• WMS_PAGE_FIELD_VALUES — Holds the permissible or configured values for each field; joined on FIELD_ID.
• WMS_PAGE_TEMPLATE_FIELDS — Associates fields with page templates; joined on FIELD_ID.
• Parent page tables (referenced via PAGE_ID) — Provide the page structure within which fields are organized.
• WMS mobile APIs and concurrent programs — Consume field configuration at runtime to render RF pages.