Search Results populate_utilization

Overview

WIP_PROD_INDICATORS is an Oracle EBS Work in Process (WIP) package owned by APPS and classified as an OTHER API in the ETRM metadata for release 12.2.2. Its purpose is to populate and maintain the manufacturing productivity indicator structures used by the WIP Business Intelligence System (BIS) reporting framework. These indicators — efficiency, utilization, yield, assembly yield, resource load, and productivity — are the quantitative measures that manufacturing and production managers rely on to evaluate how effectively resources, departments, and organizations convert available capacity into finished assemblies.

The package operates as a calculation engine rather than a transactional interface. It aggregates raw shop floor data, principally material transactions, resource availability, and calendar information, into denormalized summary tables that can be queried rapidly by productivity and efficiency reports. The header comment in the source dates the file to 2003, and the public procedure signatures retain the long-standing APPS conventions of the WIP BIS reporting suite.

Key Procedures and Functions

The package exposes 22 documented procedures and functions. The following are the principal entries:

• Load_Summary_Info — the top-level concurrent program entry point, accepting a date-from and date-to range and returning the standard errbuf and retcode pair used by concurrent managers.
• Populate_Summary_Table — populates the summary table for a specified group, organization, date range, department, and resource.
• Populate_Efficiency, Populate_Utilization, Populate_Yield — populate the corresponding productivity indicators for the same grouping and date parameters.
• Populate_Productivity — the routine targeted by searches for "populate_productivity"; it derives productivity indicator values for the requested group and date range.
• Populate_Assy_Yield — populates assembly-level yield figures.
• Populate_Resource_Load — populates resource load data used in utilization and efficiency calculations.
• Calc_Eff_Applied_Units, Calculate_Std_Quantity, Calculate_Std_Units, Calculate_Total_Quantity, Calculate_Scrap_Quantity, Calculate_Resource_Avail, Get_Workday_Ratio — supporting calculation routines that supply the quantitative inputs to the populate procedures.
• Delete_Temp_Info — clears temporary working data between runs.
• Populate_Denormalize_Data, Denormalize_Item_Dimension, Denormalize_Time_Dimension, Denormalize_Org_Dimension — build the flat dimensional structures the indicator reports read.

Tables Accessed

The package reads setup and transaction tables through APPS synonyms. BOM_CALENDAR_DATES, BOM_DEPARTMENTS, BOM_DEPARTMENT_RESOURCES, and BOM_RESOURCES provide the department, resource, and calendar context. MRP_NET_RESOURCE_AVAIL contributes resource availability, while MTL_MATERIAL_TRANSACTIONS supplies the actual consumption and completion quantities. MTL_PARAMETERS and MTL_UNITS_OF_MEASURE resolve organizational defaults and unit conversions. Output is written to the WIP_BIS_PROD_INDICATORS summary table and to the WIP_BIS_PROD_ASSY_YIELD and WIP_BIS_PROD_DEPT_YIELD tables, with transient results staged in the corresponding _TEMP tables and in WIP_BIS_EFF_TEMP and WIP_BIS_MNRA_TEMP.

Usage Notes

WIP_PROD_INDICATORS is normally invoked indirectly. The Load_Summary_Info procedure serves as the concurrent program driver, launched from the WIP responsibility to refresh productivity indicators over a chosen period. The individual Populate_* and Calculate_* procedures are called by the WIP BIS report forms and by other packages in the productivity reporting suite. Two other packages in the EBS schema reference this package. Customizations should follow the documented parameter patterns and honor the p_group_id that ties the temporary and target tables together across a calculation run; direct modification of the summary tables outside these routines risks inconsistency between indicators.