Search Results wsm_lot_split_merges_interface




Overview
Explore in AI Chat

Overview

The WSM_LOT_SPLIT_MERGES_INTERFACE table is a core interface table within the Oracle E-Business Suite (EBS) Shop Floor Management (WSM) module. It serves as the staging area for processing lot-based inventory transactions, specifically for splitting a single parent lot into multiple child lots or merging multiple parent lots into a single resulting lot. As an interface table, its primary role is to act as a temporary holding area where external systems, custom programs, or data load scripts can insert transaction data. This data is subsequently validated and processed by Oracle's standard concurrent programs or APIs to create the final inventory transactions in the core inventory tables, ensuring data integrity and business rule enforcement.

Key Information Stored

The table stores header-level information for each lot split or merge transaction request. While the specific column list is not detailed in the provided metadata, the documented relationships and standard interface patterns indicate it likely contains key control attributes. The primary key, HEADER_ID, uniquely identifies each transaction batch. The ORGANIZATION_ID links the transaction to a specific inventory organization, validated against WSM_PARAMETERS. The REASON_ID provides a reference to a documented transaction reason from MTL_TRANSACTION_REASONS. Other typical columns would include transaction quantities, dates, a transaction mode (split or merge), a process status flag (e.g., PENDING, ERROR, PROCESSED), and error message columns to capture validation failures during processing.

Common Use Cases and Queries

The primary use case is the programmatic initiation of lot splits and merges. This is essential in manufacturing and discrete industries for reworking material, adjusting lot sizes, or consolidating partial lots. A common pattern involves inserting a header record into this interface, followed by related lines in the WSM_STARTING_LOTS_INTERFACE and WSM_RESULTING_LOTS_INTERFACE tables, and then submitting the standard "Lot Split/Merge Processor" concurrent request. Key queries often focus on monitoring the interface for errors or checking the status of submitted transactions.

  • Monitoring pending transactions: SELECT header_id, organization_id, process_status FROM wsm_lot_split_merges_interface WHERE process_status = 'PENDING';
  • Investigating failed transactions: SELECT header_id, error_message FROM wsm_lot_split_merges_interface WHERE process_status = 'ERROR';
  • Joining to related interface lines: SELECT h.header_id, s.lot_number as starting_lot, r.lot_number as resulting_lot FROM wsm_lot_split_merges_interface h, wsm_starting_lots_interface s, wsm_resulting_lots_interface r WHERE h.header_id = s.header_id AND h.header_id = r.header_id;

Related Objects

The table has defined foreign key relationships with several critical interface and setup tables, forming a clear data model for lot transactions.

  • Referenced by this table (Outgoing Foreign Keys):
    • MTL_TRANSACTION_REASONS: Via WSM_LOT_SPLIT_MERGES_INTERFACE.REASON_ID. Validates the transaction reason code.
    • WSM_PARAMETERS: Via WSM_LOT_SPLIT_MERGES_INTERFACE.ORGANIZATION_ID. Validates the inventory organization.
  • Referencing this table (Incoming Foreign Keys):
    • WSM_STARTING_LOTS_INTERFACE: Links via WSM_STARTING_LOTS_INTERFACE.HEADER_ID. Stores the source parent lot(s) for the transaction.
    • WSM_RESULTING_LOTS_INTERFACE: Links via WSM_RESULTING_LOTS_INTERFACE.HEADER_ID. Stores the destination child lot(s) for the transaction.

Successful processing by the Lot Split/Merge Processor ultimately moves data from this interface structure into permanent inventory transaction tables such as MTL_MATERIAL_TRANSACTIONS and updates lot quantities in MTL_LOT_NUMBERS.