Search Results estimate_leadtime

Overview

WIP_CALENDAR is an Oracle Application Object Library packaged procedure stored under the APPS schema that supports Oracle Work in Process (WIP) and Oracle Bills of Material (BOM) scheduling logic. Its central business purpose is to calculate an estimated completion or scheduling date for a manufacturing entity by applying fixed and variable lead times, processing days, and a shop calendar to a starting date. In Oracle EBS 12.1.1 and 12.2.2, this package provides the calendar-aware date arithmetic that discrete manufacturing and repetitive scheduling rely upon when the system must respect working days, non-working periods, and the direction of scheduling (forward or backward). The package is classified as an "OTHER" API within the ETRM repository, indicating that it is an internal utility rather than a public, externally supported interface, and it is referenced by five other packages, confirming its role as a shared low-level service within the manufacturing scheduling stack.

Key Procedures and Functions

The package exposes a single documented procedure, ESTIMATE_LEADTIME. This procedure derives an estimated date by combining a base or fixed lead time with a variable lead time scaled by quantity, adding processing days, and then advancing or retreating that interval across the applicable organization calendar according to the scheduling direction. The parameters accept an organization identifier, fixed and variable lead components, an order quantity, processing days, an entity type, several date inputs and outputs, and a scheduling direction indicator, with the estimated date returned as an OUT parameter. The fixed and variable lead parameters carry default values of zero, allowing callers to supply only the lead components relevant to their calculation. Because the procedure operates on the organization's calendar, the resulting date reflects working days rather than raw calendar days, which is essential for accurate capacity and lead-time planning.

Tables Accessed

The documented table references show that WIP_CALENDAR reads BOM_CALENDAR_DATES and MTL_PARAMETERS through APPS synonyms. BOM_CALENDAR_DATES supplies the working-day and exception information that the procedure traverses to convert a lead-time interval into a valid scheduling date, honoring shifts, holidays, and calendar exceptions defined for the organization. MTL_PARAMETERS provides organization-level inventory and manufacturing parameters, including the default calendar associated with the organization, which determines which calendar the date arithmetic is applied against. Both tables are accessed for retrieval; the procedure does not maintain or update them.

Usage Notes

ESTIMATE_LEADTIME is typically invoked from within other PL/SQL packages and from scheduling routines rather than directly by end users. The five package references recorded in the metadata indicate that WIP and BOM scheduling logic calls this procedure to obtain calendar-adjusted dates when creating or rescheduling work orders and repetitive schedules. In practice it is reached indirectly through WIP job creation, WIP mass load, and BOM scheduling flows, including concurrent programs that process large volumes of manufacturing orders. Because the ETRM header shows a 2005 revision and the API is classified as OTHER, the procedure is intended for internal use and is not a supported public API; custom code should call it only with a clear understanding that its signature and behavior are not guaranteed to remain stable across releases or patches. Developers building calendar-aware scheduling logic may use it as a reference implementation, but should isolate any direct dependency behind their own wrapper to reduce upgrade exposure.