Search Results so_picking_lines_all




Overview
Explore in AI Chat

Overview

The SO_PICKING_LINES_ALL table is a core transactional table within the Oracle E-Business Suite Order Entry (OE) module, specifically for releases 12.1.1 and 12.2.2. It serves as the primary repository for individual picking line records generated during the order fulfillment process. Each row represents a specific line item from a sales order that has been allocated for picking from inventory, acting as a critical link between the sales order (SO_LINES_ALL) and the shipping execution (WSH) modules. The table's multi-org structure, indicated by the "_ALL" suffix, stores data for all operating units, with access typically controlled by a security profile.

Key Information Stored

The table's primary key is PICKING_LINE_ID, which uniquely identifies each picking line. Essential foreign key relationships define its integration points. The PICKING_HEADER_ID links the line to its parent record in SO_PICKING_HEADERS_ALL, grouping lines for a single pick release. The ORDER_LINE_ID establishes the direct connection to the originating sales order line in SO_LINES_ALL. Additional key columns include SHIP_TO_SITE_USE_ID and SHIP_TO_CONTACT_ID, which store the detailed ship-to location and contact information from RA_SITE_USES_ALL at the time of pick release, ensuring fulfillment accuracy even if the original order is updated. The table also tracks quantity-related data, such as the quantity requested and picked, which is vital for managing the pick, pack, and ship cycle.

Common Use Cases and Queries

This table is central to reporting and troubleshooting the order fulfillment pipeline. Common use cases include analyzing pick performance, reconciling order and shipment quantities, and auditing fulfillment data. A typical query joins to related order and shipping tables to report on the status of picked lines. For example, to list all picking lines for a specific order, one might use:

  • SELECT spl.picking_line_id, spl.order_line_id, sl.ordered_item, spl.requested_quantity FROM so_picking_lines_all spl, so_lines_all sl WHERE spl.order_line_id = sl.line_id AND sl.header_id = <order_header_id>;

Another critical scenario involves identifying discrepancies between ordered and picked quantities, which is essential for resolving fulfillment errors and ensuring complete shipments.

Related Objects

As per the provided metadata, SO_PICKING_LINES_ALL has extensive relationships with other EBS objects. It is a child of SO_PICKING_HEADERS_ALL and SO_LINES_ALL. It is referenced as a parent table by several key transactional entities, including SO_PICKING_LINE_DETAILS (for serial/lot allocations) and SO_PICKING_CANCELLATIONS. The table also has significant integration with localized components, as evidenced by foreign key relationships from several JAI (Oracle's India Localization) tables like JAI_OM_WSH_LINES_ALL and JAI_OM_OE_RMA_LINES. This underscores its role not only in core shipping but also in supporting region-specific legal and tax requirements for fulfillment.