Results for “release_drp”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.MSC_WS_DRP package is a PL/SQL API within the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) module that exposes Distribution Requirements Planning (DRP) functionality as a web service interface. The package is owned by the APPS schema and holds a VALID status in both Oracle EBS 12.1.1 and 12.2.2. Its primary business purpose is to enable programmatic and service-oriented invocation of DRP plan operations — launching DRP batch runs, releasing DRP results for execution, and configuring plan-level options — without requiring direct interaction with the ASCP Planner Workbench user interface. This makes it suitable for integration with external planning systems, supply chain execution applications, or scheduled batch orchestration tools.

Key Procedures and Functions

The package documents six procedures, organized as three functional pairs with an internal implementation routine and a public wrapper for each:

The public/private naming convention allows Oracle to evolve internal logic while maintaining a stable interface contract for external consumers. Parameter lists are not documented here and should be verified against the package specification in the target environment.

Tables Accessed

The package references several MSC tables through APPS synonyms, reflecting its role in the ASCP planning data model:

  • MSC_PLANS — The master plan definition table; read and updated to identify the DRP plan and its configuration.
  • MSC_ITEM_SOURCING — Defines sourcing rules used to determine how demand propagates across the distribution network.
  • MSC_TRADING_PARTNERS — Supplies supplier and customer information relevant to DRP demand/supply calculations.
  • MSC_DESIGNATORS — Provides plan designator data used to classify and segment plan output.
  • MSC_CALENDAR_DATES — Calendar data used to schedule DRP batch execution and bucket plan output.
  • DUAL — Standard Oracle single-row utility table used for lightweight queries.
  • PLITBLM — The Oracle Applications numeric table type used for passing arrays of IDs to PL/SQL APIs.

Additionally, the ETRM dependency data shows references to MSCGLBDMDSCHTBL, MSCLOCSRPDMDSCHTBL, MSCLOCSUPSCHTBL, and REQTBLTYP, which are global temporary and schema-level scheduling tables used during DRP batch processing.

Usage Notes

MSC_WS_DRP is typically invoked by the ASCP concurrent programs that drive DRP plan generation and release, by the Planner Workbench when users release DRP results, or by custom integrations that call the _PUBLIC wrappers from external applications or web service endpoints. In Oracle EBS 12.1.1 and 12.2.2, the package is shipped as part of the MSC (Advanced Planning) product family. Direct invocation of the internal (non-public) routines is not recommended, as they may change between patch levels. Developers integrating with this package should reference the live package specification and confirm the current parameter signatures in their specific environment before calling these procedures from custom code.