Search Results use_for_pick_consist_flag




Overview
Explore in AI Chat

Overview

WMS_PARAMETERS_B is the base table that stores parameter definitions for Oracle Warehouse Management (WMS) in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the WMS schema and serves as the master repository for the configurable parameters that drive the WMS rules engine, including picking, put-away, sorting, labeling, consistency checking, and operation selection logic. Each row represents a single parameter that can be referenced by rules, restrictions, sort criteria, and DB object definitions throughout the Warehouse Management module.

From a Data Vault modeling perspective, the FK structure suggests this table behaves as a hub-leaning entity. Its surrogate primary key, populated by the WMS_PARAMETERS_B_PK constraint on PARAMETER_ID, anchors relationships with numerous dependent and referencing tables, while descriptive attributes such as data type, expression, and usage flags reside locally on the same row. This pattern is characteristic of a central reference entity whose business keys are referenced widely across the transaction and configuration landscape.

Key Information Stored

The table contains 47 documented columns. The most significant include:

Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and the ATTRIBUTE1 through ATTRIBUTE15 DFF columns are also present.

Common Use Cases and Queries

WMS administrators and developers query this table to audit parameter definitions, diagnose rule behavior, and validate configuration before deployment. Typical scenarios include identifying all pick-related sort parameters, tracing which parameters feed a specific DB object, and reporting on user-defined versus seeded parameters.

A representative query to list pick sort parameters:

  • SELECT parameter_id, column_name, expression, data_type_code FROM wms_parameters_b WHERE use_for_pick_sort_flag = 'Y' AND user_defined_flag = 'Y';

To resolve the object a parameter belongs to:

  • SELECT p.parameter_id, p.column_name, o.object_name FROM wms_parameters_b p, wms_objects_b o WHERE p.object_id = o.object_id;

To surface translatable descriptions, join to WMS_PARAMETERS_TL on PARAMETER_ID. Reporting extracts commonly feed configuration migration scripts, rule engine audits, and integration setups that must replicate WMS parameter definitions across environments.

Related Objects

WMS_PARAMETERS_B is heavily referenced across the WMS configuration schema. The most significant related objects include:

Together these relationships position WMS_PARAMETERS_B as a central hub in the Warehouse Management rule configuration model.