Search Results mrp_resource_cost

Overview

MRP_EPI is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM registry as an "OTHER" API type rather than a formal public interface. Its name reflects its principal design purpose: to supply the calculation engine behind the Enterprise Performance Indicator (EPI) reporting layer of Oracle Manufacturing and Advanced Supply Chain Planning. In practical terms, MRP_EPI packages the business logic that converts raw transactional and cost data held in Oracle Inventory, Bills of Material, Cost Management, and Receivables into the derived numeric indicators that populate the EPI dashboards presented through Oracle Discoverer workbooks and Business Intelligence views. The package is a supporting dependency of the view WIP_BIS_PROD_VAL_EMP_V, which exposes production value metrics to the BIS (Business Intelligence System) layer. In Oracle EBS 12.1.1 and 12.2.2 the object remains VALID and is shipped in the standard APPS schema; it depends only on SYS.STANDARD and is not itself a schema-level standalone type. Because it is an internal engine rather than a documented public API, Oracle does not guarantee its signature across releases, and the ETRM records no formal interface parameters.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents eleven procedures and functions, grouped by indicator family:

• INVENTORY_TURNS — computes the inventory turnover indicator, expressing cost of goods consumed relative to average inventory balances over a period.
• ISSUED_VALUES and INV_VALUES — derive the value of material issued and the total inventory valuation respectively, supplying the inputs consumed by the turnover and production-value calculations.
• MRP_CALCULATE_REVENUE — determines realized revenue for the measurement window, drawing on receivables and customer data.
• MRP_ITEM_SELLING_PRICE, MRP_ITEM_LIST_PRICE, and MRP_ITEM_COST — return the selling price, list price, and standard or actual item cost used to value demand, supply, and margin indicators.
• MRP_RESOURCE_UTIL and MRP_RESOURCE_COST — calculate resource utilization percentages and the associated resource cost burden for capacity reporting.
• MRP_POPULATE_FC_SUM — populates the forecast summary work table that aggregates forecast versus actual consumption for accuracy indicators.
• PAST_DUE_MDS — identifies past-due material demands (discrete jobs and sales orders) that feed schedule attainment and backlog indicators.

Tables Accessed

The package reads through APPS synonyms across several product families. Calendar and period logic is sourced from BOM_CALENDAR_DATES, BOM_CAL_WEEK_START_DATES, BOM_PERIOD_START_DATES, and GL_PERIODS, which define the buckets over which indicators are measured. Costing data comes from CST_COST_TYPES and CST_ITEM_COSTS. Customer and location attributes used for revenue and demand analysis are drawn from HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_LOCATIONS, HZ_PARTIES, and HZ_PARTY_SITES. Reference values are resolved through FND_LOOKUP_VALUES. Output and staging data are held in MRP_BIS_FORECAST_WB and MRP_BIS_INV_DETAIL, the BIS-specific forecast workbook and inventory detail tables that the EPI layer consumes.

Usage Notes

MRP_EPI is not intended for direct invocation by end users or by customer-written code. It is normally called by the EPI concurrent programs and BIS data-collection routines that refresh the performance indicator tables, and it is surfaced indirectly through Discoverer workbooks and the WIP_BIS_PROD_VAL_EMP_V view. Because the ETRM classifies the package as OTHER with no published API contract, customizations should avoid direct calls; Oracle may change signatures without notice. Where custom reporting requires the same indicators, the supported approach is to query the MRP_BIS_* staging tables after the standard EPI refresh completes, rather than to invoke the package procedures directly.