Results for “wsm_lot_split_merges”

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

Overview

WSM_LOT_SPLIT_MERGES is the base header table for lot-based inventory transactions within the WSM (Shop Floor Management) module of Oracle E-Business Suite, applicable to releases 12.1.1 and 12.2.2. It resides in the WSM schema and is documented as VALID in the ETRM repository. The table stores the transactional header record for lot split and lot merge operations performed on the shop floor, capturing the transaction identity, type, organization context, and processing status that govern the associated lot-level detail lines held in sibling tables.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is satellite-leaning. The table is keyed by a single surrogate identifier and contains descriptive, non-key attributes — transaction dates, flags, reason references, and status fields — that characterize a business event rather than merely linking entities. Analysts building a dimensional or Data Vault layer should therefore treat it primarily as a satellite attached to a transaction hub, while recognizing that its foreign keys to MTL_TRANSACTION_REASONS and WSM_PARAMETERS introduce link-like reference dependencies.

Key Information Stored

The table contains 37 documented columns. The surrogate primary key, enforced through WSM_LOT_SPLIT_MERGES_PK, is TRANSACTION_ID. A unique index, WSM_LOT_SPLIT_MERGES_U1, is also defined on TRANSACTION_ID, making it the single documented business-key candidate and the principal join column throughout the WSM lot transaction model.

• TRANSACTION_ID — surrogate primary key uniquely identifying each lot split or merge header.
• TRANSACTION_TYPE_ID — identifies the category of lot transaction recorded.
• ORGANIZATION_ID — the inventory organization in which the transaction occurred; foreign key to WSM_PARAMETERS.
• TRANSACTION_DATE — effective date and time of the split or merge event.
• TRANSACTION_REFERENCE — free-form business reference associated with the transaction.
• SPLIT_FLAG and WIP_FLAG — indicators distinguishing split activity and work-in-process context.
• REASON_ID and TRANSACTION_REASON — reason code and descriptive reason; REASON_ID references MTL_TRANSACTION_REASONS.
• PROCESS_STATUS — current processing state of the transaction header.
• ERROR_MESSAGE — diagnostic text captured when processing fails.
• GROUP_ID — grouping identifier for related transaction sets.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program audit context.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS who-column audit trail.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard extensibility flexfield columns.

Common Use Cases and Queries

The most frequent requirement is reconciling lot split and merge activity for a given organization over a date range. A typical query joins the header to its detail tables through TRANSACTION_ID:

• Transaction history reports filtering on ORGANIZATION_ID and TRANSACTION_DATE.
• Exception reporting where PROCESS_STATUS indicates failure, using ERROR_MESSAGE for diagnostics.
• Reason analysis grouping transactions by REASON_ID joined to MTL_TRANSACTION_REASONS.
• Audit and concurrency program tracing via REQUEST_ID and PROGRAM_ID.
• Reconciliation of starting lots against resulting lots to validate split/merge quantity balance.

A representative pattern selects TRANSACTION_ID, TRANSACTION_DATE, SPLIT_FLAG, and PROCESS_STATUS from WSM_LOT_SPLIT_MERGES where ORGANIZATION_ID matches a bind parameter, then joins to WSM_SM_STARTING_LOTS and WSM_SM_RESULTING_LOTS on TRANSACTION_ID to present the before-and-after lot composition.

Related Objects

The following objects are most significant to this table based on documented key relationships:

• WSM_SM_STARTING_LOTS — references WSM_LOT_SPLIT_MERGES.TRANSACTION_ID; holds the source lots consumed by a split or merge.
• WSM_SM_RESULTING_LOTS — references WSM_LOT_SPLIT_MERGES.TRANSACTION_ID; holds the lots produced by the transaction.
• MTL_TRANSACTION_REASONS — referenced through REASON_ID for reason code validation.
• WSM_PARAMETERS — referenced through ORGANIZATION_ID for organization-level setup.
• MTL_MATERIAL_TRANSACTIONS — the related inventory transaction ledger is commonly correlated by organization, date, and reference for reconciliation.

Together these objects form the WSM lot transaction cluster, with WSM_LOT_SPLIT_MERGES acting as the authoritative header for every lot split and merge recorded on the shop floor.