Search Results opi_edw_opm_prd_pkg




Overview
Explore in AI Chat

Overview

OPI_EDW_OPM_PRD_PKG is an Oracle Application Object Library (APPS) schema package that belongs to the Oracle Process Manufacturing (OPM) integration layer feeding the Enterprise Data Warehouse (EDW) for production data. It is classified under the ETRM as an OTHER API, meaning it is not a formally published public API but is invoked internally by EDW extraction and reporting objects. The package encapsulates the business logic required to derive production metrics — grade determinations, quality sampling counts, adjustment counts, ingredient and byproduct valuations, and scheduled working days — from OPM execution tables and OPM/Inventory master data. Its primary consumer is the materialized view or fact collection object OPI_EDW_OPM_JOB_DETAIL_FCV, which pulls the functions in this package to populate job-detail level fact records for downstream warehouse reporting in Oracle EBS 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

  • FIND_PROD_GRADE — Determines the production grade associated with a production batch or item lot, resolving grade attributes used in quality and yield reporting.
  • NO_OF_SAMPLES_TAKEN — Returns the count of quality samples drawn against a batch, sourced from quality sample master data.
  • NO_OF_SAMPLES_COMPLETE — Returns the count of quality samples that have reached a completed status.
  • NO_OF_SAMPLES_PASSED — Returns the count of samples that passed their specification tests, supporting first-pass quality reporting.
  • NO_OF_TIMES_ADJUSTED — Returns the number of times a batch, ingredient, or schedule entry has been adjusted, used as a process-stability indicator.
  • INGREDIENT_VALUE — Computes the monetary or quantity value attributable to ingredients consumed in production, drawing on material detail and transaction data.
  • BYPRODUCT_VALUE — Computes the value attributable to byproducts generated during production, enabling net yield and cost reporting.
  • SCHD_WORK_DAYS — Calculates working days from the scheduling calendar, used for capacity and schedule performance metrics.

The ETRM records eight documented procedures/functions in total, all implemented within the single package body.

Tables Accessed

The package reads from the following tables via APPS synonyms:

  • IC_ITEM_MST — item master attributes for grade and valuation context.
  • IC_LOTS_MST — lot master for grade and lot-level association.
  • IC_TRAN_CMP — inventory transaction completion records for consumption and byproduct movement values.
  • PM_BTCH_HDR — batch header, the anchor for batch-level metrics.
  • MR_SHCL_DTL / MR_SHDY_DTL — resource scheduling calendar lines and days, supporting SCHD_WORK_DAYS.
  • PM_MATL_DTL — batch material detail for ingredient and byproduct derivation.
  • PS_SCHD_DTL / PS_SCHD_HDR — production schedule detail and header for schedule-level metrics and adjustments.
  • QC_SMPL_MST — quality sample master for sample counts and pass determinations.

Usage Notes

OPI_EDW_OPM_PRD_PKG is invoked indirectly rather than directly by end users. Its documented referencer is OPI_EDW_OPM_JOB_DETAIL_FCV, a fact collection view used by EDW load routines; the package also appears as self-referencing within the dependency list. Because it is classified as OTHER and is not a published public API, customizations should avoid calling its procedures directly. Typical invocation occurs during EDW refresh and OPM production reporting concurrent programs, and reporting queries should be directed to the fact collection object rather than the package itself. The ETRM records one dependent package and both [Package] and [Package Body] subobjects as VALID in 12.1.1.