Results for “locator_segments”

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

Overview

WMS_CARTONIZATION_TEMP is a temporary staging table within the Oracle E-Business Suite Inventory (INV) module, associated with the Warehouse Management System (WMS) cartonization feature. The table holds transient transactional data used during cartonization processing, in which the system determines the most efficient packing of items into shipping cartons based on item dimensions, weights, and order characteristics. Rows are typically inserted by concurrent programs or processing logic, consumed within the same processing cycle, and purged afterward. In the documented ETRM 12.1.1 schema, the table is owned by INV and contains 236 columns, making it one of the widest staging structures in the inventory transaction family. The documentation indicates that the table is not implemented in every database instance, which is consistent with its role as an implementation-dependent temporary workspace. From a Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is standalone; this serves as a modeling suggestion rather than a normative fact, and reflects the table's self-contained, process-scoped nature rather than a durable hub-and-link pattern.

Key Information Stored

The unique index WMS_CARTONIZATION_TEMP_U1 on TRANSACTION_TEMP_ID identifies that column as the primary business-key candidate and the row-level surrogate identifier. The foreign-key column TRANSACTION_HEADER_ID links rows to their parent transaction header, while CARTONIZATION_ID anchors the row to a specific cartonization grouping. Core transaction attributes include INVENTORY_ITEM_ID, ORGANIZATION_ID, REVISION, SUBINVENTORY_CODE, LOCATOR_ID, TRANSACTION_QUANTITY, PRIMARY_QUANTITY, and TRANSACTION_UOM, which define what is being processed and where. Transaction classification columns such as TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID, and TRANSACTION_MODE distinguish the operation being performed. Inventory control fields including LOT_NUMBER, SERIAL_NUMBER, LPN_ID, CONTENT_LPN_ID, CONTAINER_ITEM_ID, and CONTAINERS support carton-level packing logic. The columns SOURCE_CODE, SOURCE_LINE_ID, TRANSACTION_SOURCE_ID, and TRANSACTION_SOURCE_NAME provide context on the originating document or system. Standard audit columns include LAST_UPDATE_DATE, CREATED_BY, REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID. Process-control fields such as PROCESS_FLAG, POSTING_FLAG, REQUIRED_FLAG, ERROR_CODE, and ERROR_EXPLANATION support downstream error handling and reconciliation by the processing programs.

Common Use Cases and Queries

Cartonization processing is the predominant consumer of this table. A typical diagnostic query evaluates error rows left behind after a cartonization run:

• SELECT transaction_temp_id, inventory_item_id, organization_id, error_code, error_explanation FROM wms_cartonization_temp WHERE error_code IS NOT NULL;
• SELECT cartonization_id, COUNT(*), SUM(transaction_quantity) FROM wms_cartonization_temp GROUP BY cartonization_id;
• SELECT transaction_temp_id, process_flag, posting_flag, required_flag FROM wms_cartonization_temp WHERE posting_flag = 'N';

These queries support troubleshooting of failed cartonization cycles, verification of carton contents and quantities, and reconciliation of unposted transaction lines. Because the table is temporary, absence of rows is expected outside an active processing cycle, and production support should confirm whether rows are being staged or already purged before investigating apparent data loss.

Related Objects

The documented foreign-key relationships link WMS_CARTONIZATION_TEMP to several significant reference and transaction tables:

• MTL_TXN_SOURCE_TYPES via TRANSACTION_SOURCE_TYPE_ID — supplies valid transaction source classifications.
• SO_PICKING_LINES_ALL via PICKING_LINE_ID — links to the sales order picking line being cartonized.
• MTL_RESERVATIONS via RESERVATION_ID — ties staged rows to inventory reservations.
• MTL_MOVEMENT_STATISTICS via MOVEMENT_ID — connects movement statistics recording.
• CST_COST_GROUPS and CST_COST_TYPES via COST_GROUP_ID and COST_TYPE_ID — provide costing context.
• BOM_DEPARTMENTS via DEPARTMENT_ID — supplies department reference data.
• MTL_KANBAN_CARDS via KANBAN_CARD_ID — supports kanban-driven flows.
• WMS_OP_PLANS_B via OPERATION_PLAN_ID and WSM_OPERATION_DETAILS via STANDARD_OPERATION_ID — link to WMS operation planning.
• JAI_OM_OE_RMA_LINES via RMA_LINE_ID — associates return-line context where cartonization applies to returned goods.

These relationships confirm the table's role as an integration point between Inventory transaction processing, WMS execution, and order fulfillment flows.