Search Results date_cancelled

Overview

OEBV_ORDER_CANCELLATIONS is an Oracle E-Business Suite (EBS) database view owned by the APPS schema. It belongs to the Order Entry (OE) product family and is classified in the ETRM repository as a retrofitted object, meaning it was reconstructed to expose cancellation data through a simplified, read-only interface. The view presents order and line cancellation records captured by the Order Management module, allowing concurrent programs, reports, and integration interfaces to consume cancellation information without querying the underlying transactional tables directly.

Its principal role is to surface cancellation activity — cancel codes, comments, dates, and quantities — in a denormalized form that is stable across releases. Because the view is defined WITH READ ONLY, it is intended strictly for query and reporting purposes, not for DML. This read-only posture protects the integrity of the Order Management cancellation data while still permitting downstream extracts, dashboards, and interface lookups.

Underlying Base Objects

According to the documented ETRM metadata for 12.2.2, OEBV_ORDER_CANCELLATIONS is defined over the base object OE_ORDER_LINES_HISTORY, referenced through a synonym in the APPS schema. The view text provided in the documentation selects from SO_ORDER_CANCELLATIONS with a read-only clause, and the column list confirms a direct projection of the cancellation attributes.

The relationship to OE_ORDER_LINES_HISTORY is significant: cancellation events are historical in nature, and the Order Management data model records line-level changes — including cancellations — in history tables so that the evolution of an order line can be tracked. The view therefore acts as a compatibility and convenience layer that abstracts the physical history storage from consumers, presenting cancellation facts in a consistent shape.

Key Columns

• CANCEL_REASON / CANCEL_CODE — The code identifying why the order line was cancelled.
• CANCEL_COMMENT — Free-text comment supplied at the time of cancellation.
• DATE_CANCELLED / CANCEL_DATE — The date the cancellation was recorded.
• QUANTITY_CANCELLED / CANCELLED_QUANTITY — The quantity of the line that was cancelled.
• HEADER_ID — Foreign key to the order header, identifying the parent order.
• LINE_ID — Identifier of the specific order line affected.
• "_DF" — A descriptor column carrying the value _DF:OE:SO_ORDER_CANCELLATIONS:SO_ORDER_CANCELLATIONS, used by the EBS flexfield/descriptive framework.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — Standard audit columns inherited from the base object, supporting change tracking and audit reporting.

Common Use Cases and Queries

The view is typically used for cancellation analytics, reconciliation between order lines and their cancelled quantities, and integration extracts. A representative query listing cancellations for a given order is:

SELECT header_id, line_id, cancel_reason, cancel_comment, date_cancelled, quantity_cancelled FROM apps.oebv_order_cancellations WHERE header_id = :p_header_id ORDER BY date_cancelled DESC;

To summarize cancellation volumes by reason code over a period:

SELECT cancel_reason, COUNT(*) cancel_count, SUM(quantity_cancelled) total_qty FROM apps.oebv_order_cancellations WHERE date_cancelled BETWEEN :start_date AND :end_date GROUP BY cancel_reason ORDER BY total_qty DESC;

Because the view is read-only and projects audit columns, it is well suited to incremental extraction interfaces that filter on last_update_date. Consumers should note that the view exposes cancellation history rather than current line status; joining back to OE_ORDER_LINES_ALL on line_id is required to evaluate the present state of the order line.