Search Results msc_sce_publish_pkg




Overview
Explore in AI Chat

Overview

The APPS.MSC_SCE_PUBLISH_PKG package is a PL/SQL program unit within the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) module, part of the MSC schema family. Its principal business function is to publish planning results — specifically plan orders and associated supply/demand entries — from the planning engine staging tables into the operational tables consumed by downstream planning and execution processes. The package bridges the gap between raw plan output and the persistent supply/demand record set used by the planning data model. It is classified in the ETRM documentation with a status of VALID and an API classification of OTHER, indicating it is not a formally published public API but an internal utility invoked by planning workflows.

Key Procedures and Functions

The documented package exposes seven procedures and functions:

  • PUBLISH_PLAN_ORDERS — The primary driver routine. It processes and publishes planned orders, orchestrating the insertion of supply/demand records and the cleanup of stale data.
  • GET_OPTIONAL_INFO — Retrieves optional configuration or contextual information, likely derived from profile options and lookup values, used to govern publishing behavior.
  • INSERT_INTO_SUP_DEM — Inserts records into the supply/demand staging or operational table (MSC_SUP_DEM_ENTRIES), materializing the plan output.
  • DELETE_OLD_FORECAST — Removes obsolete forecast records to prevent duplication or stale planning data from persisting across publish cycles.
  • INSERT_INTO_SUP_DEM_RF_DOS — Inserts supply/demand entries specific to the RF (reservation/forecast) and DOS (days of supply) variant handling, distinguishing this insertion path from the standard one.
  • LOG_MESSAGE — Writes diagnostic or status messages, supporting error and progress reporting during the publish process.
  • GET_MESSAGE — Retrieves message text, typically resolving message names to localized strings using the FND message and language infrastructure.

Tables Accessed

The package reads and writes several planning and foundation tables through APPS synonyms:

Usage Notes

The package is typically invoked as part of ASCP plan publication and refresh processing rather than from an interactive form. It participates in the planning engine's data publishing workflow, where plan output must be committed into the operational supply/demand tables. Because it is classified as OTHER and is referenced by zero other packages, it should be treated as an internal implementation unit rather than a supported public API. Custom code should not call its procedures directly; instead, invoke the standard ASCP concurrent programs responsible for plan publication. Administrators should be aware that DELETE_OLD_FORECAST alters historical forecast data, so any diagnostic or troubleshooting activity must account for this behavior to avoid unintended data loss.