Search Results wms_lpn_process_temp




Overview
Explore in AI Chat

Overview

WMS_LPN_PROCESS_TEMP is a temporary staging table residing in the WMS (Warehouse Management) schema of Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. It exists to hold License Plate Number (LPN) values generated by the Generate_LPN API. When that API is invoked, it produces a set of new LPNs and returns a PROCESS_ID to the caller. The PROCESS_ID acts as a correlation handle: every row written during that specific API call shares the same PROCESS_ID value, allowing the calling program to retrieve precisely the LPNs it just generated, even when concurrent sessions are populating the same table. The table therefore functions as a short-lived buffer between LPN generation logic and the downstream process that consumes the newly created identifiers.

Under the heuristic Data Vault classification derived from its foreign key structure, this object is described as satellite-leaning. In modeling terms, this indicates the table behaves less like an independent business hub and more like a dependent, attribute-bearing structure whose identity and meaning are anchored to an external entity. Specifically, its rows describe generated LPN instances that belong to the WMS_LICENSE_PLATE_NUMBERS universe, reinforcing its role as a transient, process-scoped companion table rather than a master data store.

Key Information Stored

The documented physical schema for release 12.2.2 records exactly two columns, which reflects the deliberately narrow purpose of the table:

  • PROCESS_ID — The correlation identifier returned by the Generate_LPN API. It groups all LPN rows created during a single API invocation, enabling the caller to isolate its own generated results. This column is the practical retrieval key for any query against the table.
  • LPN_ID — The surrogate primary key of the row and a foreign key referencing WMS_LICENSE_PLATE_NUMBERS.LPN_ID. It carries the unique internal identifier of each generated license plate.

The primary key is defined by the constraint WMS_LPN_PROCESS_TEMP_PK on LPN_ID. Because the table is temporary in purpose, it holds no descriptive business attributes such as LPN numbers, statuses, or timestamps; those reside in the referenced master table. No unique business-key indexes are documented beyond the primary key.

Common Use Cases and Queries

The dominant use case is post-generation retrieval: a program calls Generate_LPN, captures the returned PROCESS_ID, and then selects the freshly generated LPN identifiers for further processing.

  • Retrieving generated LPNs for a specific process: 
    SELECT LPN_ID
FROM   WMS.WMS_LPN_PROCESS_TEMP
WHERE  PROCESS_ID = :p_process_id;
  • Joining to the master LPN table to obtain descriptive details: 
    SELECT t.PROCESS_ID, t.LPN_ID, l.LPN
FROM   WMS.WMS_LPN_PROCESS_TEMP t,
       WMS.WMS_LICENSE_PLATE_NUMBERS l
WHERE  t.LPN_ID = l.LPN_ID
AND    t.PROCESS_ID = :p_process_id;
  • Diagnostic checks to confirm how many LPNs a given process produced: 
    SELECT PROCESS_ID, COUNT(*)
FROM   WMS.WMS_LPN_PROCESS_TEMP
GROUP  BY PROCESS_ID;

Typical consumers include label printing routines, inbound receiving flows, and any custom concurrent program that needs to materialize a batch of LPNs before committing them to the master table.

Related Objects

  • WMS_LICENSE_PLATE_NUMBERS — Referenced through the foreign key WMS_LPN_PROCESS_TEMP.LPN_ID → WMS_LICENSE_PLATE_NUMBERS.LPN_ID. This is the principal parent table and the source of all descriptive LPN data.
  • Generate_LPN API — The PL/SQL API that populates this table and returns the PROCESS_ID used for retrieval.
  • WMS_LPN_PROCESS_TEMP_PK — The primary key constraint on LPN_ID that enforces row uniqueness.
  • Downstream WMS receiving and labeling programs — Consumers that select from the temp table immediately after generation to assign or print the new LPNs.