Results for “cancelled_by”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
SO_ORDER_CANCELLATIONS is an Oracle Order Entry (OE) transactional table that stores order and order line cancellation records within Oracle E-Business Suite 12.1.1 and 12.2.2. It resides in the OE schema and carries a VALID status in the ETRM repository. The table captures the audit trail of cancellations applied against sales orders and their lines, preserving who cancelled the order, when the cancellation occurred, the reason code, and the quantity affected. This makes it a critical source for order lifecycle analytics, cancellation trend reporting, and reconciliation of order status transitions.
From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying SO_ORDER_CANCELLATIONS as a link entity. It connects header-level (SO_HEADERS_ALL), line-level (SO_LINES_ALL), and user (FND_USER) hubs. This classification is a heuristic suggestion derived from the FK topology rather than a formally documented Data Vault designation.
Key Information Stored
The table contains 34 documented columns. The composite primary key SO_ORDER_CANCELLATIONS_PK is defined on HEADER_ID and LINE_ID, forming the surrogate identifier for each cancellation record. Note that the only documented unique index is SYS_IL0000040985C00034$$, an internal LOB index associated with CANCEL_COMMENT; no separate business-key unique constraint is documented beyond the composite PK.
The most significant columns include:
HEADER_ID— foreign key toSO_HEADERS_ALL; identifies the cancelled order header.LINE_ID— foreign key toSO_LINES_ALL; identifies the cancelled order line.CANCEL_CODE— reason code driving the cancellation.CANCELLED_BY— foreign key toFND_USER; the user who performed the cancellation.CANCEL_DATE— timestamp of the cancellation event.CANCELLED_QUANTITY— quantity of the line affected by the cancellation.STATUS— processing status of the cancellation record.PROCESSED_FLAG— indicator of whether the cancellation has been processed.CANCEL_COMMENT— free-text commentary stored as the LOB column.CONTEXTandATTRIBUTE1–ATTRIBUTE15— descriptive flexfield (DFF) segments for extensible attributes.CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN— standard WHO audit columns.PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,REQUEST_ID— concurrent program context identifying the originating request.
Common Use Cases and Queries
Typical scenarios include reporting cancellation rates by order, line, or user; auditing reason codes; and tracing concurrent program runs that produced cancellations. A representative join to resolve header and user details follows:
SELECT c.HEADER_ID, c.LINE_ID, c.CANCEL_CODE, c.CANCELLED_QUANTITY, c.CANCEL_DATE, u.USER_NAME FROM OE.SO_ORDER_CANCELLATIONS c, FND_USER u WHERE c.CANCELLED_BY = u.USER_ID;- Trend analysis grouped by
CANCEL_DATEandCANCEL_CODEto identify recurring cancellation drivers. - Reconciliation of unprocessed records using
PROCESSED_FLAGandSTATUSto detect incomplete cancellation flows. - Program-level audit filtering by
REQUEST_IDorPROGRAM_IDto trace batch cancellations.
Related Objects
The table participates in the following documented relationships:
SO_HEADERS_ALL— referenced viaSO_ORDER_CANCELLATIONS.HEADER_ID.SO_LINES_ALL— referenced viaSO_ORDER_CANCELLATIONS.LINE_ID.FND_USER— referenced viaSO_ORDER_CANCELLATIONS.CANCELLED_BY.- Order Entry concurrent programs and the Order Management APIs that insert cancellation rows, identifiable through
PROGRAM_IDandREQUEST_ID. - Reporting views and DFF definitions layered over
CONTEXTand theATTRIBUTEcolumns.
-
Order and order line cancellations
-
Order and order line cancellations
-
View: POBV_PLAN_PO_RELEASES 12.2.2
- Retrofitted
APPS.POBV_PLAN_PO_RELEASES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_RELEASES_ALL·Explore PO module →
-
View: AP_INVOICES_DERIVED_V 12.2.2
(Release 10SC Only)
APPS.AP_INVOICES_DERIVED_V·↳ AP_INVOICES·↳ AP_INVOICES_PKG·↳ AP_INVOICES_UTILITY_PKG·Explore AP module →
-
Detailed Brazilian consolidated invoice records
-
Detailed Brazilian consolidated invoice records
-
Cancelled picking lines
-
View: POS_PO_DETAILS_V 12.2.2
Fetches all the information related to a purchase order
APPS.POS_PO_DETAILS_V·↳ AP_TAX_CODES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·Explore POS module →
-
View: AP_INVOICES_DERIVED_V 12.1.1
(Release 10SC Only)
APPS.AP_INVOICES_DERIVED_V·↳ AP_INVOICES·↳ AP_INVOICES_PKG·↳ AP_INVOICES_UTILITY_PKG·Explore AP module →
-
View: PO_LINES_TRX_V 12.2.2
View on po_lines table.
APPS.PO_LINES_TRX_V·↳ PO_DISTRIBUTIONS_ALL·↳ PO_LINES·Explore PO module →
-
View: POBV_STD_PO_LINES 12.1.1
- Retrofitted
APPS.POBV_STD_PO_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →
-
View: POBV_PO_LINES 12.1.1
- Retrofitted
APPS.POBV_PO_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →
-
- Retrofitted
APPS.JL_BR_AP_CONSOLID_INVOICES_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ JL_BR_AP_CONSOLID_INVOICES·Explore JL module →
-
View: POBV_PLAN_PO_LINES 12.1.1
- Retrofitted
APPS.POBV_PLAN_PO_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →
-
Cancelled picking lines
-
(Release 10SC Only)
APPS.AP_INVOICES_UNION_PREPAYS_V·↳ AP_HOLDS·↳ AP_INVOICES·↳ AP_INVOICE_DISTRIBUTIONS·Explore AP module →
-
View: POFV_BKT_PO_RELEASES 12.2.2
- Retrofitted
APPS.POFV_BKT_PO_RELEASES·↳ AP_CARDS_ALL·↳ FND_CURRENCIES_VL·↳ FND_GLOBAL·Explore PO module →
-
View: POFV_BKT_PO_RELEASES 12.1.1
- Retrofitted
APPS.POFV_BKT_PO_RELEASES·↳ AP_CARDS_ALL·↳ FND_CURRENCIES_VL·↳ HR_ALL_ORGANIZATION_UNITS·Explore PO module →
-
View: POFV_PLAN_PO_LINES 12.1.1
APPS.POFV_PLAN_PO_LINES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →
-
View: POBV_PLAN_PO_RELEASES 12.1.1
- Retrofitted
APPS.POBV_PLAN_PO_RELEASES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_RELEASES_ALL·Explore PO module →
-
View: POS_PO_DETAILS_V 12.2.2
APPS.POS_PO_DETAILS_V·↳ AP_TAX_CODES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·Explore PO module →
-
View: PO_OWNED_LINES 12.1.1
Security view for owned purchase order lines
APPS.PO_OWNED_LINES·↳ PO_HEADERS_ALL·↳ PO_LINES·Explore PO module →
-
View: PO_AP_RECEIPT_MATCH_V 12.1.1
APPS.PO_AP_RECEIPT_MATCH_V·↳ AP_LOOKUP_CODES·↳ AP_TAX_CODES_ALL·↳ AP_TERMS·Explore AP module →
-
View: PO_AP_RECEIPT_MATCH_V 12.2.2
APPS.PO_AP_RECEIPT_MATCH_V·↳ AP_LOOKUP_CODES·↳ AP_SUPPLIERS·↳ AP_SUPPLIER_SITES_ALL·Explore PO module →
-
View: POBV_BKT_PO_RELEASES 12.2.2
- Retrofitted
APPS.POBV_BKT_PO_RELEASES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_RELEASES_ALL·Explore PO module →
-
View: POBV_BKT_PO_RELEASES 12.1.1
- Retrofitted
APPS.POBV_BKT_PO_RELEASES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_RELEASES_ALL·Explore PO module →
-
View: AP_PO_CORRECTIONS_V 12.1.1
APPS.AP_PO_CORRECTIONS_V·↳ AP_INVOICES_ALL·↳ AP_INVOICE_LINES_ALL·↳ AP_LOOKUP_CODES·Explore AP module →
-
View: POS_PO_ARCH_SUMMARY_V 12.2.2
APPS.POS_PO_ARCH_SUMMARY_V·↳ AP_TERMS·↳ FND_CURRENCY_CACHE·↳ FND_GLOBAL·Explore POS module →
-
View: POS_PO_SUMMARY_V 12.1.1
APPS.POS_PO_SUMMARY_V·↳ AP_TERMS·↳ FND_CURRENCY_CACHE·↳ FND_GLOBAL·Explore PO module →
-
APPS.SO_ORDER_CANCELLATIONS_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ MTL_SYSTEM_ITEMS_KFV·Explore OE module →
-
APPS.SO_ORDER_CANCELLATIONS_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ MTL_SYSTEM_ITEMS_KFV·Explore OE module →
-
View: POS_PO_SUMMARY_V 12.2.2
APPS.POS_PO_SUMMARY_V·↳ AP_TERMS·↳ FND_CURRENCY_CACHE·↳ FND_GLOBAL·Explore PO module →
-
View: PO_RELEASES_V 12.1.1
10SC ONLY - Retrofitted
APPS.PO_RELEASES_V·↳ AP_TERMS·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·Explore PO module →
-
Displays Blankets
APPS.POS_PO_SUPPLIER_AGREEMENTS_V·↳ AP_TERMS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore POS module →
-
APPS.POS_PO_SUPPLIER_AGREEMENTS_V·↳ AP_TERMS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore PO module →
-
APPS.POS_PO_SUPPLIER_AGREEMENTS_V·↳ AP_TERMS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore PO module →
-
APPS.AP_RECEIPT_CORRECTIONS_V·↳ AP_INVOICES_ALL·↳ AP_INVOICE_LINES_ALL·↳ AP_LOOKUP_CODES·Explore AP module →
-
View: AP_INVOICES_V 12.1.1
APPS.AP_INVOICES_V·↳ AP_AWT_GROUPS·↳ AP_BATCHES_ALL·↳ AP_DISTRIBUTION_SETS·Explore AP module →
-
View: POFV_PLAN_PO_LINES 12.2.2
APPS.POFV_PLAN_PO_LINES·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →
-
View: POBV_PLAN_PO_LINES 12.2.2
- Retrofitted
APPS.POBV_PLAN_PO_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →
-
- Retrofitted
APPS.JL_BR_AP_CONSOLID_INVOICES_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ JL_BR_AP_CONSOLID_INVOICES·Explore JL module →
-
View: POFV_PLAN_PO_RELEASES 12.1.1
- Retrofitted
APPS.POFV_PLAN_PO_RELEASES·↳ AP_CARDS_ALL·↳ FND_CURRENCIES_VL·↳ HR_ALL_ORGANIZATION_UNITS·Explore PO module →
-
View: POFV_PLAN_PO_RELEASES 12.2.2
- Retrofitted
APPS.POFV_PLAN_PO_RELEASES·↳ AP_CARDS_ALL·↳ FND_CURRENCIES_VL·↳ FND_GLOBAL·Explore PO module →
-
Archived releases
-
(Release 10SC Only)
APPS.AP_INVOICES_UNION_PREPAYS_V·↳ AP_HOLDS·↳ AP_INVOICES·↳ AP_INVOICE_DISTRIBUTIONS·Explore AP module →
-
View: PO_AP_RECEIPT_MATCH_V 12.1.1
APPS.PO_AP_RECEIPT_MATCH_V·↳ AP_LOOKUP_CODES·↳ AP_TAX_CODES_ALL·↳ AP_TERMS·Explore PO module →
-
APPS.AP_RECEIPT_CORRECTIONS_V·↳ AP_INVOICES·↳ AP_INVOICE_LINES_ALL·↳ AP_LOOKUP_CODES·Explore AP module →
-
View: POBV_BKT_PO_LINES 12.2.2
- Retrofitted
APPS.POBV_BKT_PO_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →
-
View: POBV_BKT_PO_LINES 12.1.1
- Retrofitted
APPS.POBV_BKT_PO_LINES·↳ HR_ALL_ORGANIZATION_UNITS·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →
-
Obsolete
APPS.ICX_PO_HDR_ARCHIVE_OPEN_V·↳ AP_TERMS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore ICX module →