Search Results wip_indicators_temp_s

Overview

WIP_SFCB_UTILITIES is an Oracle EBS Work in Process (WIP) package body owned by the APPS schema. The suffix "SFCB" identifies it as part of the Shop Floor Control / shop floor execution business layer, and the utility nature of the package indicates that it supplies shared computational and data-gathering services rather than exposing a single public API transaction. In practice, WIP_SFCB_UTILITIES provides the calculation engine behind work-in-process productivity reporting: it computes efficiency, utilization, productivity, and resource or line load measures for discrete jobs and flow schedules, and it resolves the routing, department, resource, and calendar context required to produce those measures. The package status is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and the documented API classification is OTHER, meaning that it is not itself a supported public interface but a supporting implementation package.

Key Procedures and Functions

ETRM documents 31 procedures and functions. The measurement-population programs are POPULATE_EFFICIENCY, POPULATE_UTILIZATION, POPULATE_PRODUCTIVITY, POPULATE_RESOURCE_LOAD, and POPULATE_LINE_LOAD, which calculate the respective performance or load metrics and write them into the WIP indicator structures. POPULATE_LINE_RESOURCE_LOAD performs the same function restricted to a specific production line and its assigned resources. RESOURCE_TXN and UPDATE_LINE_OPERATION support resource-level transaction handling and the maintenance of line operation records.

The remaining routines supply context and control. SET_ORGANIZATION, SET_LINE, and SET_LINEARITY_DATES establish the operating organization, production line, and date range for a calculation run, with matching GET_ORGANIZATION, GET_LINE, GET_LINEARITY_FROM_DATE, and GET_LINEARITY_TO_DATE accessors. LINE_OP_IS_PENDING and CHECK_LAST_LINE_OP evaluate the state of line operations, GET_ALL_LINE_OPS returns the operations belonging to a line, GET_WORKDAY_FACTOR derives the working-day conversion factor from the shop calendar, and DISPLAYDATE_TO_DISPLAYDT formats date values for display purposes.

Tables Accessed

The package reads the routing and resource model through BOM_OPERATIONAL_ROUTINGS, BOM_OPERATION_SEQUENCES and BOM_OPERATION_SEQUENCES_V, BOM_OPERATION_RESOURCES, BOM_RESOURCES, BOM_STANDARD_OPERATIONS, BOM_DEPARTMENTS, and BOM_DEPARTMENT_RESOURCES_V. Calendar-based adjustments use BOM_CALENDAR_DATES and MRP_NET_RESOURCE_AVAIL, while MTL_PARAMETERS supplies organization-level defaults. Work order data is drawn from WIP_DISCRETE_JOBS, WIP_FLOW_SCHEDULES, WIP_LINES, and WIP_OPEN_FLOW_SCHEDULES_V. The calculated results are staged in WIP_INDICATORS_TEMP and its serialized partner WIP_INDICATORS_TEMP_S, then posted to WIP_PROD_INDICATORS; this explains the user search on WIP_INDICATORS_TEMP_S, whose matches arise from the package's dependency list. OKE_K_DELIVERABLES_B is referenced for deliverable-level data, and standard utilities such as FND_API, FND_DATE, FND_FILE, FND_GLOBAL, FND_ATTACHMENT_UTIL_PKG, FND_INSTALLATION, FLM_TIMEZONE, BOM_RTG_NETWORK_API, WIP_TRANSACTION_PUB, and WIP_TRANSACTION_PVT are used for formatting, messaging, and transaction support.

Usage Notes

WIP_SFCB_UTILITIES is not referenced by any database object in the ETRM dependency report, but it is referenced by seven other packages, indicating that it is called indirectly through the shop floor reporting and production-indicator programs rather than as a standalone entry point. Invocation typically occurs from the WIP production productivity and line-load reporting flows, where a concurrent program first seeds organization, line, and linearity dates, then executes the populate routines to stage results in WIP_INDICATORS_TEMP and commit them to WIP_PROD_INDICATORS. Because the package is classified as OTHER rather than a public API, customizations should not call it directly; instead, custom code should rely on the documented WIP public APIs and treat WIP_SFCB_UTILITIES as an internal implementation detail whose signature may change without notice.