Search Results so_picking_cancellations




Overview
Explore in AI Chat

Overview

The table SO_PICKING_CANCELLATIONS is a core transactional data object within the Oracle E-Business Suite (EBS) Order Entry (OE) module. It serves as a critical audit and control table, specifically designed to record instances where previously allocated or "picked" order lines are subsequently canceled from the fulfillment process. This table provides a persistent historical record of picking cancellations, enabling businesses to track changes in order fulfillment status, analyze cancellation reasons, and maintain data integrity between the order management and shipping execution workflows. Its existence is essential for accurate inventory reconciliation and for providing a complete audit trail of all picking activities.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the foreign key relationships and standard EBS table design patterns indicate the table stores key identifiers and metadata related to the cancellation event. Crucial data points typically include the PICKING_LINE_ID, which links directly back to the original picking record in SO_PICKING_LINES_ALL, and the LINE_ID, which references the sales order line in SO_LINES_ALL. Other common columns would capture the cancellation date and time, the identifier of the user who performed the cancellation, and potentially a reason code or comments field documenting why the picking was canceled. This structure ensures every canceled picking line can be traced to its source order and picking transaction.

Common Use Cases and Queries

This table is primarily used for operational reporting and troubleshooting. A common use case is generating reports to analyze picking cancellation trends by item, warehouse, or reason code to identify process inefficiencies. Database administrators and support analysts query this table to investigate inventory discrepancies, as a cancellation should result in the allocated quantity being returned to available stock. A typical diagnostic SQL pattern joins SO_PICKING_CANCELLATIONS to the picking and order lines tables to get the full context of the canceled item.

SELECT sl.ordered_item,
       sl.line_number,
       pcl.creation_date AS cancel_date,
       pcl.last_updated_by
  FROM oe.so_picking_cancellations pcl,
       oe.so_picking_lines_all    pl,
       oe.so_lines_all            sl
 WHERE pcl.picking_line_id = pl.picking_line_id
   AND pcl.line_id = sl.line_id
   AND sl.header_id = :p_order_header_id;

Related Objects

The ETRM metadata explicitly documents two primary foreign key relationships for the SO_PICKING_CANCELLATIONS table, anchoring it firmly within the Order Management schema.

  • SO_PICKING_LINES_ALL: Joined via the column SO_PICKING_CANCELLATIONS.PICKING_LINE_ID. This is the most direct relationship, linking each cancellation record to the specific picking line that was voided.
  • SO_LINES_ALL: Joined via the column SO_PICKING_CANCELLATIONS.LINE_ID. This relationship ties the cancellation back to the original sales order line, providing access to item, quantity, and order header information.

This table is a child of these key transactional tables, and it may be referenced by custom reports or data extracts for fulfillment analysis.