Search Results msc_x_planning




Overview
Explore in AI Chat

Overview

MSC_X_PLANNING is an APPS-owned PL/SQL package within the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) module. It resides in the MSC schema family, which encompasses the tables, views, and program units used by Oracle Advanced Planning and Scheduling. In Oracle EBS 12.1.1 and 12.2.2, the package is documented with a status of VALID and is classified as an "OTHER" API, meaning it is not a formally published open interface but rather an internal utility package invoked by other planning components.

The package supports demand planning calculations and diagnostic output. Its primary business role centers on computing average demand figures used in replenishment and vendor-managed inventory (VMI) processing. The package operates alongside complementary units such as MSC_X_REPLENISH, which references it, forming part of the planning engine's supporting logic for sourcing and supplier-based demand evaluation.

Key Procedures and Functions

The ETRM metadata documents four procedures and functions within this package:

  • CALCULATE_AVERAGE_DEMAND — The core computational routine. It derives average demand values from planning data, typically aggregating historical or forecast demand for use in replenishment decisions and supplier collaboration calculations.
  • CALCULATE_AVERAGE_DEMAND_API — A public wrapper exposing the average-demand calculation logic. This entry point is intended for invocation by external planning programs or dependent packages such as MSC_X_REPLENISH, providing a controlled interface to the underlying calculation.
  • PRINT_DEBUG_INFO — A diagnostic utility that emits debug information, generally gated by a debug flag or profile option. It assists developers and support analysts in tracing execution during planning runs.
  • PRINT_USER_INFO — A diagnostic routine that outputs user-context information, useful for auditing or troubleshooting which user session or parameters drove a given planning calculation.

Parameter lists are not documented in the available metadata and should be confirmed against the package specification in the target environment before direct invocation.

Tables Accessed

The package references the following tables through APPS synonyms:

  • MSC_ITEM_SUPPLIERS — Stores item-to-supplier sourcing relationships, including sourcing rules and supplier assignments. The package reads this data to associate demand with the appropriate supplier for VMI and replenishment calculations.
  • MSC_SUP_DEM_ENTRIES — Holds supplier demand entries, providing the demand quantities over which averaging is performed.
  • MSC_VMI_TEMP — A temporary working table used to stage VMI-related calculations during processing, supporting intermediate results before final output.

Usage Notes

MSC_X_PLANNING is not intended for direct end-user invocation. It is typically called by the planning engine and by sibling packages; ETRM documentation confirms MSC_X_REPLENISH as a dependent caller. Because the package is classified as OTHER rather than a supported open API, customizations that call it directly should be validated carefully after patches or upgrades.

Diagnostic procedures (PRINT_DEBUG_INFO, PRINT_USER_INFO) are useful during concurrent planning program execution when tracing unexpected demand averages or VMI output. Developers should always invoke CALCULATE_AVERAGE_DEMAND_API in preference to the internal routine, and should verify the package specification in the specific EBS version (12.1.1 or 12.2.2) before relying on signatures.