Results for “so_picking_lines_u1”

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

Overview

OE.SO_PICKING_LINES_ALL is a transactional table in the Oracle Order Management (OE) schema that stores the individual picking lines associated with a picking header. A picking header represents a pick release batch, and each picking line records the allocation of a specific order line, inventory item, and quantity to that batch. The table is central to the pick-release to ship-confirm flow, serving as the operational bridge between sales order lines and warehouse execution activities such as material transactions and shipping.

The user search term so_picking_lines_u1 refers to the unique index SO_PICKING_LINES_U1, which enforces uniqueness on the PICKING_LINE_ID column. This index functions as the primary business-key enforcement mechanism and corresponds to the primary key SO_PICKING_LINES_PK. Because the table carries standard Who columns, workflow metadata, and a dense set of foreign key references, it behaves as a transactional hub. The heuristic Data Vault classification is hub-leaning, meaning SO_PICKING_LINES_ALL can be modeled as the central hub, with picking header, order line, and customer/item attributes acting as links or satellites around it.

Key Information Stored

The table contains 61 documented columns. The most operationally significant are:

• PICKING_LINE_ID — System-generated surrogate identifier and the sole column of the SO_PICKING_LINES_U1 unique index; primary key of the table.
• PICKING_HEADER_ID — Foreign key to SO_PICKING_HEADERS_ALL, identifying the pick release batch containing this line.
• ORDER_LINE_ID — Foreign key to SO_LINES_ALL, tying the picking line back to the originating sales order line.
• INVENTORY_ITEM_ID — The inventory item being picked; a primary driver of nonunique index SO_PICKING_LINES_N1.
• REQUESTED_QUANTITY — Quantity that has been reserved for the picking line.
• ORIGINAL_REQUESTED_QUANTITY — Total originally ordered quantity.
• SHIPPED_QUANTITY — Quantity actually shipped against this picking line.
• CANCELLED_QUANTITY — Quantity cancelled from the picking line.
• WAREHOUSE_ID — Warehouse from which the items are picked.
• SEQUENCE_NUMBER — Ordinal position of the picking line within the batch.
• SHIP_TO_SITE_USE_ID / SHIP_TO_CONTACT_ID — Ship-to destination references (RA_SITE_USES_ALL and a contact reference).
• RA_INTERFACE_STATUS — Status used by the Receivables interface.
• INVENTORY_STATUS — Status controlling whether the line is eligible for inventory activity.
• ORG_ID — Operating unit identifier, required for multi-org reporting.
• BO_PICKING_LINE_ID — Backorder picking line reference, indexed by SO_PICKING_LINES_N6.

Common Use Cases and Queries

Typical reporting includes pick-release reconciliation, shipped-versus-requested variance analysis, open picking line tracking, and cancellation auditing. A query to reconcile picking activity by header follows:

• SELECT p.PICKING_HEADER_ID, p.ORDER_LINE_ID, p.INVENTORY_ITEM_ID, p.REQUESTED_QUANTITY, p.SHIPPED_QUANTITY, p.CANCELLED_QUANTITY FROM OE.SO_PICKING_LINES_ALL p WHERE p.PICKING_HEADER_ID = :batch AND p.ORG_ID = :org_id;
• SELECT l.PICKING_LINE_ID, l.ORDER_LINE_ID, l.INVENTORY_ITEM_ID FROM OE.SO_PICKING_LINES_ALL l WHERE l.INVENTORY_ITEM_ID = :item_id AND l.RA_INTERFACE_STATUS = 'N';
• SELECT COUNT(*), SUM(p.SHIPPED_QUANTITY) FROM OE.SO_PICKING_LINES_ALL p WHERE p.PICKING_HEADER_ID = :batch GROUP BY p.WAREHOUSE_ID;

Because the table is large and transactional, filters should leverage the unique index on PICKING_LINE_ID, the nonunique indexes on INVENTORY_ITEM_ID, ORDER_LINE_ID, RA_INTERFACE_STATUS, INVENTORY_STATUS, and the composite PICKING_HEADER_ID/WAREHOUSE_ID index. Always constrain on ORG_ID in multi-org environments.

Related Objects

• OE.SO_PICKING_HEADERS_ALL — Joined on PICKING_HEADER_ID; parent batch record.
• OE.SO_LINES_ALL — Joined on ORDER_LINE_ID; originating sales order line.
• OE.SO_PICKING_LINE_DETAILS — Child table referencing PICKING_LINE_ID, storing allocation detail.
• OE.SO_PICKING_CANCELLATIONS — Child table referencing PICKING_LINE_ID, recording cancellations.
• MTL_MATERIAL_TRANSACTIONS / MTL_TRANSACTIONS_INTERFACE — Reference PICKING_LINE_ID to link inventory transactions to picking lines.
• MTL_MOVEMENT_STATISTICS — Both referenced by MOVEMENT_ID and references PICKING_LINE_ID.
• WSH_LINES_ALL (and JAI_OM_WSH_LINES_ALL) — Shipping lines that inherit PICKING_LINE_ID for downstream delivery and India localization processing.
• RA_SITE_USES_ALL — Joined on SHIP_TO_SITE_USE_ID for ship-to site data.
• MTL_CUSTOMER_ITEMS — Joined on CUSTOMER_ITEM_ID.