Search Results so_order_cancellations




Overview
Explore in AI Chat

Overview

The SO_ORDER_CANCELLATIONS table is a core transactional data object within the Oracle E-Business Suite (EBS) Order Entry (OE) module, specifically for versions 12.1.1 and 12.2.2. As defined by the ETRM, its primary function is to record the history of order and order line cancellations. It serves as the official system of record for tracking when and why sales orders or specific lines are canceled, providing a critical audit trail. This table is essential for operational reporting, customer service inquiries, and financial reconciliation processes, ensuring data integrity for all cancellation-related activities.

Key Information Stored

The table's structure, as indicated by its primary and foreign key relationships, is designed to link cancellation records directly to the specific order header and line. While the full column list is not detailed in the provided excerpt, the foreign key constraints explicitly identify several critical columns. The HEADER_ID and LINE_ID together form the primary key (SO_ORDER_CANCELLATIONS_PK), uniquely identifying a cancellation record for a specific order line. The CANCELLED_BY column stores a reference to the user who performed the action, linking to the FND_USER table. Typical data stored would also include timestamps (e.g., cancellation date), cancellation reason codes, quantities canceled, and potentially a reference to any related return material authorization (RMA).

Common Use Cases and Queries

This table is central to generating cancellation analysis reports and auditing user activity. A common business use case is analyzing cancellation trends by product, customer, or sales representative to identify root causes. For customer service, queries against this table provide immediate visibility into the cancellation history of a specific order. A typical SQL pattern involves joining to the order headers and lines tables to retrieve contextual information.

  • Sample Query for Cancellation Audit: SELECT oh.order_number, ol.line_number, soc.cancelled_date, fu.user_name FROM oe.so_order_cancellations soc JOIN oe.so_headers_all oh ON soc.header_id = oh.header_id JOIN oe.so_lines_all ol ON soc.line_id = ol.line_id JOIN applsys.fnd_user fu ON soc.cancelled_by = fu.user_id WHERE oh.order_number = '<ORDER_NUM>';
  • Reporting Use Case: Generating a monthly report of canceled lines by item category and cancellation reason, often joined with INV.MTL_SYSTEM_ITEMS_B for item details.

Related Objects

The SO_ORDER_CANCELLATIONS table has defined foreign key relationships with several fundamental EBS tables, as documented in the ETRM metadata. These relationships enforce referential integrity and dictate standard join conditions for queries.

  • SO_HEADERS_ALL: Links via SO_ORDER_CANCELLATIONS.HEADER_ID = SO_HEADERS_ALL.HEADER_ID. This provides access to the overall order information like order number, customer, and date.
  • SO_LINES_ALL: Links via SO_ORDER_CANCELATIONS.LINE_ID = SO_LINES_ALL.LINE_ID. This provides details on the specific item, quantity, and price of the canceled line.
  • FND_USER: Links via SO_ORDER_CANCELLATIONS.CANCELLED_BY = FND_USER.USER_ID. This provides the identity (user name) of the person who performed the cancellation.