Search Results wms_transactions_temp_u1

Overview

The WMS_TRANSACTIONS_TEMP table is a global temporary table within the Oracle E-Business Suite Warehouse Management System (WMS). Its primary role is to serve as a transient, session-private staging area for material transaction data before it is processed and posted to permanent inventory tables. As a global temporary table with a transaction-level duration (SYS$TRANSACTION), data inserted by a session is only visible to that session and is automatically purged upon transaction completion (commit or rollback). This design is critical for ensuring data integrity and isolation during complex warehouse transaction processing, such as mobile device transactions, receiving, and picking, preventing concurrent sessions from interfering with each other's in-progress work.

Key Information Stored

The table stores a comprehensive set of attributes defining a pending inventory movement. Key columns include the primary identifier PP_TRANSACTION_TEMP_ID and the associated TRANSACTION_TEMP_ID. It captures core transaction details like TYPE_CODE and LINE_TYPE_CODE to classify the transaction, along with item specifics such as REVISION, LOT_NUMBER, and SERIAL_NUMBER. The table records both source (FROM_SUBINVENTORY_CODE, FROM_LOCATOR_ID) and destination (TO_SUBINVENTORY_CODE, TO_LOCATOR_ID) logistics information, including organization and cost group identifiers. Quantities are stored in TRANSACTION_QUANTITY, PRIMARY_QUANTITY, and SECONDARY_QUANTITY. The table also links to the originating document via TRANSACTION_SOURCE_ID and TRANSACTION_SOURCE_LINE_ID.

Common Use Cases and Queries

This table is central to real-time warehouse operations. A primary use case is staging data from a handheld RF device scan; the transaction details are written here temporarily, validated by business logic, and then used to generate permanent records in MTL_MATERIAL_TRANSACTIONS_TEMP and related tables. For troubleshooting, one might query a session's pending transactions. Given the user's search for "pp_transaction_temp_id," a common query pattern involves joining this table to other transaction interfaces or log tables using this key.

• Sample Query to Review Session Data:
  SELECT pp_transaction_temp_id, transaction_source_name, from_subinventory_code, to_subinventory_code, transaction_quantity
  FROM wms.wms_transactions_temp
  WHERE transaction_source_id = :p_source_id;
• Use in Reporting: While the table itself is temporary, its structure informs the design of real-time dashboards that monitor transaction processing queues by querying the associated permanent interface or transaction tables after the temporary data is processed.

Related Objects

The table's relationships are primarily defined through its indexes, which indicate logical joins to other transaction-processing entities. The unique index WMS_TRANSACTIONS_TEMP_U1 on PP_TRANSACTION_TEMP_ID is the primary key. The non-unique index WMS_TRANSACTIONS_TEMP_N1 on (TRANSACTION_TEMP_ID, TYPE_CODE, LINE_TYPE_CODE) suggests a relationship with a parent transaction header or interface table. Similarly, index WMS_TRANSACTIONS_TEMP_N2 on (TO_SUBINVENTORY_CODE, TO_LOCATOR_ID) indicates joins for locator validation. This table is a direct precursor to the MTL_MATERIAL_TRANSACTIONS_TEMP table, where validated data is moved for final cost and inventory accounting processing before becoming a permanent transaction in MTL_MATERIAL_TRANSACTIONS.