Search Results wms_label_set_formats




Overview
Explore in AI Chat

Overview

The WMS_LABEL_SET_FORMATS table is a core configuration object within the Oracle Warehouse Management (WMS) module of Oracle E-Business Suite. It supports the Label-set feature, which allows warehouse operations to group multiple label formats into a single logical set that can be generated together during outbound, inbound, or inventory transactions. Each row in this table establishes the association between a label set and one of the individual formats that compose it, enabling the WMS labeling engine to resolve the complete collection of formats required for a given transaction type.

The table resides in the WMS schema and is documented as VALID in ETRM 12.2.2. The heuristic Data Vault classification derived from the foreign-key structure is standalone. In Data Vault modeling terms, this table functions as a link-style relationship holder: it captures the many-to-many association between label sets and label formats. Because no parent hub is declared on the set side within the mined metadata, the table is best modeled as an independent association entity rather than a pure link between two fully governed hubs.

Key Information Stored

The documented physical schema for this table contains eight columns. The most significant are:

  • SET_ID — Identifies the label set to which the format belongs. This is the primary business identifier on the parent (set) side of the relationship.
  • FORMAT_ID — Identifies the individual label format assigned to the set. This column carries the documented foreign key to BSC_SYS_FORMATS, confirming that formats are centrally defined and referenced here.
  • DISABLE_DATE — Provides soft-delete / end-dating semantics. A populated value indicates that the association is no longer active, allowing historical label-set composition to be retained without physical deletion.
  • CREATION_DATE and CREATED_BY — Standard WHO audit columns recording when and by whom the association row was created.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — Standard WHO audit columns capturing the most recent modification and the login context of the updater.

No explicit unique index is documented in the supplied metadata, but in practice the combination of SET_ID and FORMAT_ID functions as the effective business key, since a given format should appear only once per active set. The surrogate primary key is not enumerated in the documented column list, but the presence of the two identifying columns plus WHO audit columns is consistent with a composite association table.

Common Use Cases and Queries

Typical use cases revolve around resolving which formats belong to a set and auditing historical composition. A common query pattern joins the table to BSC_SYS_FORMATS to retrieve format details for an active set:

  • Resolving active formats for a set: SELECT FORMAT_ID FROM WMS_LABEL_SET_FORMATS WHERE SET_ID = :set_id AND (DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE);
  • Auditing set composition changes over time by examining CREATION_DATE, LAST_UPDATE_DATE, and DISABLE_DATE.
  • Reporting on formats that appear across multiple sets to identify reuse or duplication.
  • Diagnosing missing-label issues during shipping or receiving by confirming that the expected FORMAT_ID values are present and not disabled for the transaction's label set.

Related Objects

The most significant related objects are:

  • BSC_SYS_FORMATS — Referenced through FORMAT_ID; holds the definition of each individual label format.
  • WMS_LABEL_SETS (and related set-definition tables) — The parent entity identified by SET_ID, defining the set itself.
  • WMS_LABEL_FORMATS and associated label-print APIs — Consume the resolved format list during label generation.
  • BSC_SYS_FORMAT_PARAMETERS — Defines parameters used when a format is rendered.
  • WMS label-printing concurrent programs and PL/SQL APIs — Depend on this table to build the format collection for a transaction.