Search Results wms_shipping_transaction_temp




Overview
Explore in AI Chat

Overview

The WMS_SHIPPING_TRANSACTION_TEMP table is a temporary staging table within the Oracle E-Business Suite Warehouse Management (WMS) module. Its primary role is to act as a transient data repository during the mobile ship confirmation process in Oracle EBS releases 12.1.1 and 12.2.2. This process involves confirming shipments via mobile devices or RF terminals on the warehouse floor. The table temporarily holds transaction data—such as delivery, trip, and item details—before this data is validated and permanently posted to core shipping and inventory transaction tables. Its temporary nature is critical for ensuring data integrity and managing transaction state during the complex, multi-step confirmation workflow.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented foreign key relationships reveal the essential transactional entities captured. Key columns include DELIVERY_DETAIL_ID and DELIVERY_ID, linking to specific shipment lines and delivery documents. The TRIP_ID associates the transaction with a freight movement. Inventory specifics are stored via INVENTORY_ITEM_ID and ORGANIZATION_ID, while physical handling is tracked through PARENT_LPN_ID and OUTERMOST_LPN_ID for license plate management, and DOCK_DOOR_ID for the shipment location. The table typically includes status flags, transaction quantities, and a unique session or process identifier to manage the lifecycle of the temporary records.

Common Use Cases and Queries

The primary use case is the real-time processing of mobile ship confirmations. Data is inserted into this table by the mobile interface, where it awaits validation by concurrent processes before final posting. Common queries involve monitoring pending confirmations or troubleshooting stuck transactions. For instance, a developer might use a query to identify unprocessed records for a specific delivery or session. A typical diagnostic SQL pattern would join to related master tables to inspect the staged data:

  • SELECT wstt.*, wdd.source_line_id FROM wms_shipping_transaction_temp wstt, wsh_delivery_details wdd WHERE wstt.delivery_detail_id = wdd.delivery_detail_id AND wstt.process_flag = 'PENDING';

Reporting directly on this table is uncommon, as it holds transient data. However, it is crucial for auditing the ship confirmation process flow and debugging errors before data commits to permanent tables.

Related Objects

As indicated by its foreign keys, WMS_SHIPPING_TRANSACTION_TEMP is a central nexus connecting key shipping and inventory entities. Major related objects include:

Data from this table is ultimately processed and moved into permanent inventory transaction tables (e.g., MTL_MATERIAL_TRANSACTIONS) and shipping transaction tables, completing the fulfillment cycle.