Search Results pmifv_prod_effi_v




Overview
Explore in AI Chat

Overview

PMIFV_PROD_EFFI_V is a read-only reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the PMI - Process Manufacturing Intelligence product family. Its documented purpose is the analysis of batch efficiency in process manufacturing environments. The view consolidates batch execution data from the GME batch tables with item master, plant inventory, organization, and GL calendar information to produce a single denormalized result set suitable for efficiency reporting and downstream integration.

The view is defined WITH READ ONLY, confirming it is intended strictly for query and extraction rather than transactional use. It is valid in both 12.1.1 and 12.2.2, and the underlying 12.2.2 metadata lists synonyms in the APPS schema pointing to the FND-managed base objects, which is consistent with the EBS synonym-based data model. The view supports period-by-period efficiency measurement by joining completed batches to the PMI GL calendar, allowing comparison of actual and planned quantities within a fiscal period context.

Underlying Base Objects

The view is defined over the following documented base objects:

  • GME_BATCH_HEADER (synonym) — provides batch-level data including plant, warehouse, batch number, formula reference, status, and actual completion date.
  • GME_MATERIAL_DETAILS (synonym) — supplies item-level material lines, actual and planned quantities, units of measure, and line type.
  • SY_ORGN_MST (synonym) — resolves plant code to company code.
  • IC_ITEM_MST (synonym) — the item master, supplying item number, description, planning class, inventory class, and sales class.
  • IC_PLNT_INV (synonym) — plant inventory parameters, supplying standard quantity and lead-time attributes. This is the object referenced by the search term ic_plnt_inv.
  • FM_FORM_MST_B (synonym) — the formula master, used to validate the batch's associated formula.
  • PMI_GL_CALENDAR_V (view) — provides fiscal year, period number, and period name with period start and end dates.
  • GMICUOM (package) — performs unit-of-measure conversion through the I2UOM_CV function.
  • PMI_COMMON_PKG (package) — retrieves item cost via PMICO_GET_COST.
  • PMI_SECURITY_PKG (package) — enforces organization-level security through SHOW_RECORD.

Joins are driven by BATCH_ID, ITEM_ID, PLANT_CODE, and company code, with the completion date range-checked against the GL calendar period boundaries.

Key Columns

  • PLANT_CODE / COMPANY_CODE / WHSE_CODE — organizational context for the batch.
  • BATCH_ID / BATCH_NO — batch identifier and user-facing batch number.
  • ITEM_ID / ITEM_NO / ITEM_DESC — item identity from the item master.
  • PLANNING_CLASS, INVENTORY_CLASS, SALES_CLASS — item classification attributes.
  • FISCAL_YEAR, PERIOD_CODE, PERIOD_NAME — GL period in which the batch completed.
  • ACTUAL_YIELD_ — converted actual quantity, normalized to the item's primary UOM via GMICUOM.I2UOM_CV.
  • STD_QTY — standard quantity from IC_PLNT_INV.
  • Actual and planned cost columns — derived by multiplying converted planned/actual quantities by the item cost returned from PMI_COMMON_PKG.PMICO_GET_COST, evaluated at the batch completion date and warehouse.

Common Use Cases and Queries

Typical usage includes batch yield efficiency reporting, period-over-period production comparisons, and cost-versus-plan analysis. Organization security is applied automatically through PMI_SECURITY_PKG, so results are inherently filtered to the plants the querying user is authorized to see.

A representative query, for example comparing actual yield and cost by period:

  • SELECT plant_code, period_name, item_no, actual_yield_, std_qty FROM apps.pmifv_prod_effi_v WHERE fiscal_year = 2024 ORDER BY plant_code, period_name;
  • SELECT batch_no, item_no, actual_yield_ FROM apps.pmifv_prod_effi_v WHERE plant_code = :plant AND period_code = :period;

Because the view references packages in its select list, performance is best served by filtering on plant, fiscal year, and period before aggregating.