Results for “default_conversion_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view MRP_AP_UOM_CONVERSIONS_V is a database object within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environment, delivered under the MRP – Master Scheduling/MRP product family. It exposes unit-of-measure (UOM) conversion information associated with the Advanced Planning (AP) schema used by Oracle's Master Scheduling and MRP applications. The view consolidates item-level UOM conversion data alongside organization- and plan-level surrogate keys (RN1, RN2, RN3), which are internally generated record numbers used to reconcile planning snapshot data.

This view is primarily referenced by MRP and Advanced Supply Chain Planning processes that require a normalized, read-only perspective of UOM conversion rates tied to inventory items. Because the underlying sources are snapshot tables (_SN suffix), the view reflects planning-run-specific data rather than live transactional records. This distinction is critical: the view is not a real-time operational source but a planning-time snapshot representation.

Per the documented metadata, the view is marked "Not implemented in this database," which indicates it exists in the ETRM reference repository but may not be physically installed in every environment, depending on the planning module configuration.

Underlying Base Objects

The view is defined over the following snapshot tables:

• MRP_AP_UOM_CNVS_SN – The primary source table containing UOM conversion records, aliased as X.
• MRP_AP_MRP_PARAS_SN – The MRP parameters snapshot, aliased as MP, supplying the organization-level context.
• MRP_AP_SYS_ITEMS_SN – The system items snapshot, aliased as MSI, providing inventory item and organization relationships.

The view uses a UNION ALL construct. The first branch isolates records where INVENTORY_ITEM_ID = 0 (non-item-specific conversions), assigning RN1, RN2, and RN3 all as zero. The second branch joins item-specific conversion rows in MRP_AP_UOM_CNVS_SN to a derived subquery (aliased Y) that computes MAX(MSI.RN) and MAX(MP.RN), grouped by INVENTORY_ITEM_ID. This design ensures that each item-level conversion is tagged with the correct snapshot record numbers, enabling downstream planning engines to match conversions against the appropriate plan and organization snapshot.

Key Columns

• UNIT_OF_MEASURE – The descriptive UOM name (e.g., Each, Kilogram).
• UOM_CODE – The standardized internal code for the unit of measure.
• UOM_CLASS – The classification group (e.g., Quantity, Weight, Volume) to which the UOM belongs.
• INVENTORY_ITEM_ID – The item with which the conversion is associated; a value of 0 denotes a non-item-specific conversion.
• CONVERSION_RATE – The multiplication factor converting from one UOM to another.
• DEFAULT_CONVERSION_FLAG – Indicates whether this conversion is the default for the item/UOM combination.
• DISABLE_DATE – The date on which the conversion record becomes inactive.
• RN1, RN2, RN3 – Snapshot record numbers linking the row to the relevant MRP plan parameters and system item snapshots.

Common Use Cases and Queries

Typical usage involves validating that planning snapshot conversions align with expected item definitions, or diagnosing discrepancies in MRP output caused by stale or missing UOM data.

Example query retrieving item-specific conversions:

SELECT unit_of_measure, uom_code, inventory_item_id, conversion_rate
FROM   mrp_ap_uom_conversions_v
WHERE  inventory_item_id > 0
AND    disable_date IS NULL;

The view is also joined to planning result tables via RN1/RN2/RN3 to map conversions to specific plan runs. Because it is a snapshot-based view, it should be queried within the context of an active or archived MRP plan, and results should not be treated as a substitute for the live MTL_UOM_CONVERSIONS table.