Results for “wms_label_formats_u2”

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

Overview

WMS.WMS_LABEL_FORMATS is a seed-data configuration table in the Oracle Warehouse Management System (WMS) module of Oracle E-Business Suite, present and valid in both 12.1.1 and 12.2.2. It stores the catalog of label formats defined for each label type (document id) in the system. During label printing execution, the WMS rules engine evaluates the configured label rules and selects an appropriate label format from this table to print. A single label type may have any number of associated label formats, each representing a distinct combination of legitimate fields defined for that label type.

From a Data Vault modeling perspective, the heuristic classification of this table is hub-leaning. The table behaves as a durable business-key registry: each row carries a stable surrogate identifier (LABEL_FORMAT_ID) and a stable business key (LABEL_FORMAT_NAME), while surrounding descriptive and operational attributes (printer assignment, EPC configuration, disable dates, descriptive flexfields) can be viewed as satellite context. Modelers should treat WMS_LABEL_FORMATS as the hub for label format identity, with dependent references from transaction and history tables.

Key Information Stored

The table is owned by the WMS schema and resides in the APPS_TS_SEED tablespace, reflecting its role as seed/configuration reference data. The most significant columns include:

• LABEL_FORMAT_ID — surrogate primary key (WMS_LABEL_FORMATS_PK1); unique identifier for the format.
• LABEL_FORMAT_NAME — business-key candidate; the unique format name enforced by unique index WMS_LABEL_FORMATS_U2 (with ZD_EDITION_NAME in 12.2.2).
• FORMAT_DESCRIPTION — human-readable description of the label format.
• DOCUMENT_ID — the label type to which the format belongs; formats are grouped by this value.
• DEFAULT_FORMAT_FLAG — indicates whether the format is the default for its label type when no rule determines a different format.
• FORMAT_DISABLE_DATE — date on which the format becomes inactive.
• PRINTER_NAME — printer associated with the format.
• GENERATE_EPC, EPC_RULE_ID, EPC_RULE_TYPE, EPC_CATEGORY_ID, FILTER_VALUE — Electronic Product Code generation and rule configuration.
• LABEL_ENTITY_TYPE — the entity type the label applies to.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield columns for extensible client-specific data.
• WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, plus concurrent columns REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.
• ZD_EDITION_NAME — editioning column supporting EBS 12.2 online patching.

The unique indexes WMS_LABEL_FORMATS_U1 (LABEL_FORMAT_ID) and WMS_LABEL_FORMATS_U2 (LABEL_FORMAT_NAME), each in 12.2.2 combined with ZD_EDITION_NAME, reinforce these as the surrogate and business-key candidates respectively.

Common Use Cases and Queries

Typical scenarios include identifying the default label format per label type, auditing disabled formats, and tracing which formats drive label requests. Sample SQL patterns:

• List active default formats per label type:
  SELECT label_format_id, label_format_name, document_id FROM wms.wms_label_formats WHERE default_format_flag = 'Y' AND (format_disable_date IS NULL OR format_disable_date > SYSDATE);
• Retrieve all formats for a given label type:
  SELECT label_format_id, label_format_name, format_description FROM wms.wms_label_formats WHERE document_id = :p_document_id;
• Join to label requests to trace usage:
  SELECT r.label_request_id, f.label_format_name FROM wms.wms_label_requests r JOIN wms.wms_label_formats f ON r.label_format_id = f.label_format_id;
• EPC configuration reporting:
  SELECT label_format_name, generate_epc, epc_rule_type FROM wms.wms_label_formats WHERE generate_epc = 'Y';

These queries support label configuration reviews, migration validation, and operational troubleshooting when printed labels do not match expectations.

Related Objects

The following tables reference WMS_LABEL_FORMATS through LABEL_FORMAT_ID and are the most significant dependents:

• WMS.WMS_LABEL_REQUESTS — active label print requests; joins on LABEL_FORMAT_ID.
• WMS.WMS_LABEL_REQUESTS_HIST — historical label requests; joins on LABEL_FORMAT_ID for audit and trend reporting.
• WMS.WMS_LABEL_FIELD_VARIABLES — defines the field variables associated with each format; joins on LABEL_FORMAT_ID and links to the label type's field definitions.

Together, these relationships confirm the table's hub-leaning nature: WMS_LABEL_FORMATS anchors format identity, while request, history, and field-variable tables record the transactional and structural linkage to each defined format.