Search Results msc_ws_collections




Overview
Explore in AI Chat

Overview

The APPS.MSC_WS_COLLECTIONS package body is a Web Services–oriented PL/SQL wrapper within the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) and Demand Signal Repository (DSR / Demand Management) product families. Its business purpose is to expose a controlled, programmatic entry point through which external or integrated clients can trigger the data collection and loading processes that feed the ASCP planning engine and the demand management schema. Collection in this context refers to the extraction of source transactional data — shipment bookings, RMA, currency conversions, unit-of-measure conversions, pricing, and returns history — from operational sources into the planning and demand repositories.

The package is owned by APPS and is documented with a status of VALID. It is classified as OTHER rather than as a public API, reflecting its role as an internal service layer rather than a formally published integration contract. It is not referenced by any other database object, which confirms that it sits at the outer edge of the dependency graph and is intended to be invoked directly by callers.

Key Procedures and Functions

The package exposes sixteen documented subprograms, organized as eight functional pairs. In each pair, the base routine performs the core work and the _PUB variant provides the published (typically callable-from-outside, standard-argument) form of the same operation.

  • RUNASCPCOLLECTIONS / RUNASCPCOLLECTIONS_PUB — Drives the ASCP collections process, initiating the standard collection run that gathers source data for supply chain planning.
  • RUNODSLOAD / RUNODSLOAD_PUB — Executes the Operational Data Store load, moving staged source records into the ODS structures consumed by planning.
  • RUNDEMANTRASHIPMENTBOOKING / RUNDEMANTRASHIPMENTBOOKING_PUB — Collects shipment booking transactions into the demand management repository.
  • RUNDEMANTRASCIDATA / RUNDEMANTRASCIDATA_PUB — Loads ASCI (Advanced Supply Chain Intelligence) related data for the demand management track.
  • RUNDEMANTRACURRCONVERSION / RUNDEMANTRACURRCONVERSION_PUB — Applies currency conversion to collected demand data so that values are expressed in the planning currency.
  • RUNDEMANTRAUOMCONVERSION / RUNDEMANTRAUOMCONVERSION_PUB — Performs unit-of-measure conversion, normalizing quantities to the standard planning UOM.
  • RUNDEMANTRAPRICINGDATA / RUNDEMANTRAPRICINGDATA_PUB — Collects and loads pricing data associated with demand transactions.
  • RUNDEMANTRARETURNSHISTORY / RUNDEMANTRARETURNSHISTORY_PUB — Loads historical returns data into the demand management tables.

Tables Accessed

The documented table references, resolved through APPS synonyms, include:

  • MSC_APPS_INSTANCES — Identifies the registered EBS application instances participating in the collection, supporting multi-instance and multi-organization collection scenarios.
  • MSD_DEM_RMA_TYPE — Supplies the RMA type definitions used when processing returns-related demand data.
  • DUAL — Used for single-row evaluations and simple constant selection.
  • PLITBLM — The standard PL/SQL table type used for in-memory collections when passing array data between program units.

Usage Notes

The package depends on several supporting objects, notably MSC_WS_COMMON, MSC_ORG_GROUPS_V, MSD_DEM_ORG_GROUPS_V, MSD_DEM_COMMON_UTILITIES, MSCCHAR255ARR, FND_REQUEST, FND_SUBMIT, and FND_LOOKUP_VALUES_VL. The presence of FND_REQUEST and FND_SUBMIT indicates that the package submits concurrent programs on behalf of the caller rather than performing all processing inline. This is the typical pattern for web service entry points that must return quickly while long-running collection jobs execute in the concurrent manager. Invocation is expected from web service clients, integration middleware, or custom code rather than from standard EBS forms, and the _PUB routines should be used by external callers where available.