Search Results msc_cl_gmp_utility




Overview
Explore in AI Chat

Overview

MSC_CL_GMP_UTILITY is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides utility and integration routines bridging Oracle Process Manufacturing (OPM/GMP) master data with Oracle Advanced Supply Chain Planning (ASCP) collection and planning structures. The package name reflects its role: "MSC_CL" identifies the Advanced Planning collection layer, while "GMP" denotes the Process Manufacturing application family. Its principal business function is to extract, validate, and stage process manufacturing effectivities, formulas, routings, resources, and calendar information so that ASCP can consume accurate planning data for process-enabled organizations.

The package is classified under the generic "OTHER" API classification and contains seventy-nine documented procedures and functions, indicating a wide utility surface rather than a narrow business API. It acts as a supporting technical layer invoked by collection programs and companion packages rather than as an end-user-facing interface.

Key Procedures and Functions

The documented routines cluster into several functional groups:

Collectively these routines normalize OPM manufacturing definitions into the flat, planning-ready form required by ASCP.

Tables Accessed

Through APPS synonyms the package touches several categories of tables. Process manufacturing source tables include GMD_OPERATIONS (routing operations), GMP_CALENDAR_DETAIL_GTMP (calendar detail staging), GMP_DEMANDS_API (demand interface), GMP_RESOURCE_AVAIL and GMP_RESOURCE_INSTANCES (resource availability and instances), and CR_RSRC_DTL (resource detail). Item master data is read from IC_ITEM_MST, and shift data from BOM_SHIFT_DATES.

Planning staging tables include MSC_ST_BOMS, MSC_ST_BOM_COMPONENTS, MSC_ST_CALENDAR_DATES, MSC_ST_CAL_WEEK_START_DATES, MSC_ST_DEMANDS, and MSC_ST_DESIGNATORS; these are the "MSC_ST_" collection interface tables populated for ASCP. FND_APPLICATION is referenced for application context. Together these reads and writes support extraction and staging of process data for the planning engine.

Usage Notes

MSC_CL_GMP_UTILITY is referenced by GMP_CALENDAR_PKG, MSC_CL_PULL, and itself, confirming it is driven by the ASCP collection process (MSC_CL_PULL) and by OPM calendar processing. It is typically invoked indirectly through planning collection concurrent programs and process manufacturing calendar setup rather than from a form. Customizations should treat it as an internal utility: callers should rely on documented procedures only, avoid direct dependency on internal logic, and preserve the staging table contract expected by ASCP. Validations such as VALIDATE_FORMULA and VALIDATE_ROUTING can be reused in controlled custom code before collection runs, but changes to staged data should be made only through these routines to maintain planning consistency.