Search Results net_commission




Overview
Explore in AI Chat

Overview

PMI_EDW_MARGIN_F_IV is an Oracle E-Business Suite database view belonging to the Process Manufacturing Intelligence (PMI) module. It functions as an interface view (denoted by the _IV suffix) exposing margin fact data in a denormalized, analytics-ready format suitable for consumption by the Enterprise Data Warehouse (EDW) and downstream business intelligence reporting. The view presents order-level and line-level margin, pricing, cost, and commission information, making it a central artifact for profitability analysis in process manufacturing environments running EBS 12.1.1 or 12.2.2.

The ETRM metadata records the object as "Not implemented in this database," which is significant: the view is defined in the product schema for extraction and integration purposes but is not necessarily instantiated in every environment. For the user searching on commission_code, this view is directly relevant because it explicitly projects a COMMISSION_CODE column, along with related commission and pricing measures such as NET_COMMISSION, BASE_PRICE, NET_PRICE, COST, and MARGIN_PK.

Underlying Base Objects

The ETRM metadata documents no referenced base objects, but the view text itself provides the authoritative definition: all columns are sourced from a single underlying fact table, PMI_EDW_MARGIN_F. The view is therefore a straightforward projection with no joins or aggregation.

  • Base table: PMI_EDW_MARGIN_F
  • Derived column: ROWID ROW_ID — the physical row identifier of the base table row, carried through for change-detection and ETL delta processing.
  • Derived column: USER_ATTRIBUTE15 OPERATION_CODE — a rename aliasing the fifteenth descriptive flexfield attribute segment as an operation or change-type indicator, a common EDW convention for marking insert, update, or delete operations.

Because PMI_EDW_MARGIN_F is a fact table, the view inherits its grain, which is a single margin line tied to order and shipment context.

Key Columns

The view exposes roughly sixty columns spanning pricing, costing, commission, logistics, and descriptive flexfields.

Common Use Cases and Queries

Typical scenarios include extracting margin, commission, and pricing facts into the warehouse, analyzing commission performance by code, and reconciling margin lines to their originating orders. The following query isolates commission-related margin lines:

SELECT order_number, line_number, commission_code, net_commission, base_price, net_price, cost, currency_fk_key, operation_code FROM pmi_edw_margin_f_iv WHERE commission_code IS NOT NULL AND net_commission > 0 ORDER BY order_number, line_number;

To summarize realized margin by commission code:

SELECT commission_code, SUM(net_price - cost) total_margin, SUM(net_commission) total_commission, COUNT(*) line_count FROM pmi_edw_margin_f_iv GROUP BY commission_code ORDER BY total_margin DESC;

For incremental EDW loads, ROW_ID and OPERATION_CODE support delta extraction. Analysts should note that availability depends on whether the view is implemented in the target database, as the ETRM metadata records it as not implemented in the documented instance.