Search Results msc_sce_loads_pkg




Overview
Explore in AI Chat

Overview

MSC_SCE_LOADS_PKG is an Oracle EBS Applications (APPS) schema PL/SQL package that belongs to the Advanced Supply Chain Planning (ASCP) module, specifically the Supply Chain Engine (SCE) load-processing layer. Its object name, containing the "SCE_LOADS" token, indicates its role in the loading, validation, and processing of data into the supply chain planning engine — most notably supply/demand entries used during plan runs. In 12.1.1 and 12.2.2, ASCP uses the MSC (Materials/Supply Chain) schema objects to stage and publish planning data, and this package acts as a utility and validation library invoked across that pipeline. It carries an API classification of OTHER, meaning it is an internal engine utility package rather than a formally published public API, though it is referenced by twelve other packages in the MSC namespace.

Key Procedures and Functions

The documented package exposes nineteen procedures and functions covering four broad concerns:

Tables Accessed

The package reads and writes both ASCP planning tables and shared FND infrastructure, all via APPS synonyms:

Usage Notes

As an internal ASCP engine utility, MSC_SCE_LOADS_PKG is invoked programmatically rather than through a standalone form. Its documented callers — including MSC_SCE_PUBLISH_PKG, MSC_SCE_PUB_SUPPLY_COMMIT_PKG, MSC_CL_PUBLISH, MSC_EXCHANGE_BUCKETING, MSC_X_HZ_UPDATE, and the MSC_X_NETTING family (MSC_X_NETTING1_PKG through 4, MSC_X_NETTING_PKG, MSC_X_RECEIVE_CAPACITY_PKG, and MSC_X_WFNOTIFY_PKG) — confirm it is called during plan publication, netting, capacity, and workflow-notification processing. Customers are advised to treat it as a private dependency: it may be invoked indirectly during plan runs, data collection, or publishing, but direct calls from custom code risk breakage because the package is not a supported public API. Any modifications should be avoided, and diagnostics should leverage its error-string and logging routines only through supported planning processes.