Search Results upload_forecast




Overview
Explore in AI Chat

Overview

MSC_WS_APS_DATA_SERVICES is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It forms part of the Advanced Planning and Scheduling (APS) Web Services layer within the MSC (Advanced Supply Chain Planning) module, providing the server-side interface through which external planning engines, partner applications, and integration clients exchange planning data with the EBS planning schema.

Its primary business role is the bulk movement of forecast, safety stock, and planned supply records between external systems and the MSC planning tables. The package abstracts the complexity of array-based, set-oriented loading and extraction, allowing external advanced planning systems to synchronize demand and supply data without directly manipulating MSC base tables. Its close coupling with MSC_WS_COMMON and MSC_WS_APS_DATA_SERVICES' sibling packages confirms it is a member of a structured web service utility family rather than a standalone API. The package is classified as OTHER in the API taxonomy, signifying it is an internal integration service rather than a supported public interface.

Key Procedures and Functions

The ETRM metadata documents five entry points:

  • UPLOAD_FORECAST — Transfers forecast entries from an external source into the planning schema, populating the forecast record and table structures.
  • DOWNLOAD_FORECAST — Extracts forecast data from the planning schema and returns it to a calling external system for use in its own planning computations.
  • UPLOAD_SAFETY_STOCKS — Loads safety stock quantities for items, organizations, and buckets into the MSC_SAFETY_STOCKS structure.
  • DOWNLOAD_SAFETY_STOCKS — Retrieves current safety stock definitions and returns them to the requesting application.
  • UPLOAD_PLANNED_SUPPLY — Feeds externally computed planned supply orders back into the MSC_SUPPLIES structures so they become visible to the planner.

Parameter lists are not documented in the ETRM extract and are deliberately not reproduced here.

Tables Accessed

The package operates primarily against MSC_SUPPLIES and its DDL-synchronized table MSC_SUPPLIES_S, which anchor planned supply uploads. Forecast operations touch the forecast record and table collections, while safety stock operations read and write MSC_SAFETY_STOCKS. Reference and validation data are drawn from MSC_ITEMS, MSC_SYSTEM_ITEMS, MSC_PLANS, MSC_PLAN_BUCKETS, MSC_PLAN_ORGANIZATIONS, MSC_DEMAND_CLASSES, and FND_LOOKUP_VALUES. Trading partner context is resolved through MSC_TRADING_PARTNERS, MSC_TP_ID_LID, and MSC_TP_SITE_ID_LID. Project-related planning uses MSC_PROJECTS and MSC_PROJECT_TASKS, with PJM_PROJECT_PARAMETERS and MSC_PROJECT_PARAMETERS supplying project setup flags. Additional reads include MSC_APPS_INSTANCES, MSC_REGIONS, and the MSD_DEMAND_PLANS / MSD_DP_SCENARIOS family, indicating scenario-aware data handling when the source planning application is a demand planning scenario.

Usage Notes

MSC_WS_APS_DATA_SERVICES is not referenced by any other database object, confirming it is invoked directly by external web service clients rather than from within other PL/SQL units. It is typically triggered through the MSC web service adapter layer, which serializes request payloads into the PL/SQL record and array types used by this package. Related lookup data is resolved at call time from the same web service layer.

Users searching for "msc_supplies_s" will find that this package is the principal consumer of that table in the web service context. Because the API classification is OTHER, the package is not covered by Oracle's public API compatibility guarantee; customizations should avoid direct invocation and instead use the supported web service entry points. The status is VALID in the documented environment.