Results for “wms_label_requests_hist”

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

Overview

WMS_LABEL_REQUESTS_HIST is a Warehouse Management (WMS) history table in the Oracle E-Business Suite that stores all label requests that have been submitted through the labeling infrastructure. It resides in the WMS schema and is classified as VALID in both Oracle EBS 12.1.1 and 12.2.2. Where the transactional table WMS_LABEL_REQUESTS captures the active or working set of label requests, this history table provides a durable audit trail that persists after requests complete, fail, or are purged from the operational table. This makes it the authoritative source for retrospective analysis of labeling activity across receiving, put-away, picking, shipping, and inventory transactions.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is standalone. This suggests the table functions as a self-contained artifact that can be modeled as an independent satellite or hub rather than a pure link entity. In practice, it carries descriptive history keyed on a natural label request identifier.

Key Information Stored

The table contains 69 columns. The most significant for reporting and reconciliation are:

• LABEL_REQUEST_ID — The primary business key. A unique index (WMS_LABEL_REQUESTS_HIST_U1) enforces uniqueness on this column, and it is the documented FK to WMS_LABEL_REQUESTS.
• REQUEST_DATE, REQUEST_USER_ID — When and by whom the label request was submitted.
• JOB_NAME, REQUEST_MODE_CODE, BUSINESS_FLOW_CODE — The concurrent job, execution mode, and Oracle EBS business flow context.
• LABEL_TYPE_ID, LABEL_FORMAT_ID — The label template and format applied; LABEL_FORMAT_ID joins to WMS_LABEL_FORMATS.
• PRINTER_NAME, OUTFILE_NAME, OUTFILE_DIRECTORY, NO_OF_COPY, ENCODING — Output targeting and copy controls.
• ORGANIZATION_ID, INVENTORY_ITEM_ID, SUBINVENTORY_CODE, LOCATOR_ID — Inventory context for the label.
• LOT_NUMBER, REVISION, SERIAL_NUMBER, LPN_ID — Lot, serial, and license plate tracking.
• DELIVERY_ID, DELIVERY_DETAIL_ID, PACKAGE_ID, SALES_ORDER_HEADER_ID, SALES_ORDER_LINE_ID — Shipping and order linkage.
• CUSTOMER_ID, CUSTOMER_SITE_ID, CUSTOMER_ITEM_ID, SUPPLIER_ID, SUPPLIER_SITE_ID — Trading partner references; CUSTOMER_ITEM_ID joins to MTL_CUSTOMER_ITEMS.
• STATUS_FLAG, JOB_STATUS, PRINTER_STATUS, STATUS_TYPE, ERROR_MESSAGE — Outcome and diagnostic state.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program provenance.
• LABEL_CONTENT — Stored payload or reference to the generated label content.

Common Use Cases and Queries

Typical scenarios include auditing label throughput, troubleshooting failed prints, and reconciling shipping docs against generated labels. A representative query lists recent failures:

SELECT label_request_id, request_date, printer_name, job_status, error_message
FROM wms.wms_label_requests_hist
WHERE job_status = 'ERROR'
AND request_date >= SYSDATE - 7
ORDER BY request_date DESC;

Volume reporting by organization and printer:

SELECT organization_id, printer_name, COUNT(*)
FROM wms.wms_label_requests_hist
WHERE request_date BETWEEN :p_from AND :p_to
GROUP BY organization_id, printer_name;

Related Objects

• WMS_LABEL_REQUESTS — Operational source; joined on LABEL_REQUEST_ID.
• WMS_LABEL_FORMATS — Label format definitions; joined on LABEL_FORMAT_ID.
• MTL_CUSTOMER_ITEMS — Customer item cross-reference; joined on CUSTOMER_ITEM_ID.
• WMS_LABEL_TYPES — Label type master referenced by LABEL_TYPE_ID.
• MTL_SYSTEM_ITEMS_B — Item master for INVENTORY_ITEM_ID.
• MTL_ITEM_LOCATIONS — Locator validation for LOCATOR_ID.
• WMS_LPN_HISTORY — LPN lifecycle context for LPN_ID.
• WSH_DELIVERY_DETAILS — Shipping detail linkage.
• Concurrent program requests via REQUEST_ID link to FND_CONCURRENT_REQUESTS for scheduling diagnostics.