Results for “msc_ws_drp”
50+ 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:
- LAUNCH_DRP_BATCH — Internal routine that initiates a DRP batch run for a specified plan.
- LAUNCH_DRP_BATCH_PUBLIC — Public wrapper exposing the batch launch capability to external callers.
- RELEASE_DRP — Internal routine that performs the release of DRP-planned orders into the execution system.
- RELEASE_DRP_PUBLIC — Public wrapper for releasing DRP results.
- SET_DRP_PLAN_OPTIONS — Internal routine that configures DRP plan parameters and options.
- SET_DRP_PLAN_OPTIONS_PUBLIC — Public wrapper for setting DRP plan options.
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.
-
PACKAGE: APPS.MSC_WS_DRP 12.2.2
-
PACKAGE: APPS.MSC_WS_DRP 12.1.1
-
TYPE: APPS.MSCGLBDMDSCHTBL 12.1.1
-
TYPE: APPS.MSCGLBDMDSCHTBL 12.2.2
-
TYPE: APPS.REQTBLTYP 12.1.1
-
TYPE: APPS.MSCLOCSUPSCHTBL 12.2.2
-
TYPE: APPS.MSCLOCSUPSCHTBL 12.1.1
-
TYPE: APPS.REQTBLTYP 12.2.2
-
TYPE: APPS.REQRECTYP 12.1.1
-
TYPE: APPS.MSCIGLBDMDSCHREC 12.1.1
-
TYPE: APPS.MSCGLBDMDSCHREC 12.1.1
-
TYPE: APPS.REQRECTYP 12.2.2
-
TYPE: APPS.MSCILOCDMDSCHTBL 12.2.2
-
TYPE: APPS.MSCIGLBDMDSCHTBL 12.1.1
-
TYPE: APPS.MSCILOCDMDSCHTBL 12.1.1
-
TYPE: APPS.MSCIGLBDMDSCHTBL 12.2.2
-
TYPE: APPS.MSCIGLBDMDSCHREC 12.2.2
-
TYPE: APPS.MSCILOCDMDSCHREC 12.2.2
-
TYPE: APPS.MSCILOCSUPSCHTBL 12.1.1
-
TYPE: APPS.MSCILOCSUPSCHTBL 12.2.2
-
TYPE: APPS.MSCILOCDMDSCHREC 12.1.1
-
TYPE: APPS.MSCGLBDMDSCHREC 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
SYNONYM: APPS.MSC_PLANS 12.2.2
-
SYNONYM: APPS.MSC_PLANS 12.1.1
-
PACKAGE: APPS.MSC_WS_DRP 12.1.1
-
PACKAGE: APPS.MSC_WS_DRP 12.2.2