Search Results wms_label_formats




Overview
Explore in AI Chat

Overview

WMS_LABEL_FORMATS is a Warehouse Management (WMS) module table in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments. It stores the master list of label formats that have been defined in the system for each label type. During label printing execution, the WMS rules engine evaluates the defined business rules and selects an appropriate label format from this table, which is then rendered and sent to the specified printer. In this manner, WMS_LABEL_FORMATS acts as the central repository that connects label business rules to the physical label templates associated with documents such as receipts, put-away labels, LPN labels, shipping labels, and material handling labels.

From a data modeling perspective, the heuristic Data Vault classification for this object is hub-leaning. This classification is inferred from its foreign key structure, where the table is the referenced parent for several dependent tables but does not itself carry heavy transactional history in its base columns. As a modeling suggestion, WMS_LABEL_FORMATS is best treated as a hub entity keyed on the label format identifier, with its descriptive attributes and edition-based change history modeled separately.

Key Information Stored

WMS_LABEL_FORMATS is a wide table containing 39 documented columns in the 12.2.2 schema. The most significant columns include:

  • LABEL_FORMAT_ID — The surrogate primary key of the table, backed by the unique index WMS_LABEL_FORMATS_PK1. It uniquely identifies each label format record and is referenced by dependent tables.
  • LABEL_FORMAT_NAME — The business-facing name of the label format. Combined with the edition column, it forms a unique business key through the WMS_LABEL_FORMATS_U2 index.
  • FORMAT_DESCRIPTION — A descriptive text field explaining the purpose or contents of the label format.
  • DOCUMENT_ID — Links the label format to its underlying document definition used during rendering.
  • DEFAULT_FORMAT_FLAG — Indicates whether the format is the default selection for its label type when the rules engine evaluates candidate formats.
  • FORMAT_DISABLE_DATE — The date on which the label format becomes inactive and is no longer eligible for selection.
  • LABEL_ENTITY_TYPE — Specifies the business entity type (for example, LPN or item) to which the label format applies.
  • PRINTER_NAME — Identifies the target printer associated with the format.
  • GENERATE_EPC, EPC_RULE_ID, EPC_RULE_TYPE, and EPC_CATEGORY_ID — Govern Electronic Product Code generation behavior for RFID-enabled label formats.
  • FILTER_VALUE — A selection constraint used by the rules engine when matching formats.
  • ZD_EDITION_NAME — The edition column supporting edition-based redefinition and record versioning.
  • Standard WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and the ATTRIBUTE1 through ATTRIBUTE15 descriptive flexfield columns.

Common Use Cases and Queries

The most common practical scenario is identifying which label formats are currently active and available for a given label type. A typical query filters out disabled formats:

  • Query active label formats by name or description: SELECT label_format_id, label_format_name, format_description FROM wms_label_formats WHERE format_disable_date IS NULL OR format_disable_date > SYSDATE;
  • Identify the default label format for a given entity type: SELECT label_format_name FROM wms_label_formats WHERE default_format_flag = 'Y' AND label_entity_type = :entity_type;
  • Trace which label requests used a specific format by joining to WMS_LABEL_REQUESTS on LABEL_FORMAT_ID to support audit and troubleshooting of printed labels.
  • Report on EPC-enabled formats using GENERATE_EPC and the associated EPC rule columns for RFID compliance reporting.

These queries are frequently used in label troubleshooting, warehouse configuration migration, and reporting on label printing activity.

Related Objects

The following objects depend on or reference WMS_LABEL_FORMATS through documented foreign key relationships:

  • WMS_LABEL_REQUESTS — References WMS_LABEL_FORMATS via LABEL_FORMAT_ID, capturing each label printing request.
  • WMS_LABEL_REQUESTS_HIST — The historical counterpart, also referencing LABEL_FORMAT_ID for printed label audit trails.
  • WMS_LABEL_FIELD_VARIABLES — References WMS_LABEL_FORMATS via LABEL_FORMAT_ID, defining the variable fields available on each label format.

Together these children make WMS_LABEL_FORMATS the anchor of the WMS label printing configuration model, with the base table functioning as the hub and the request and field-variable tables acting as dependent satellites.