Search Results set_srp_plan_options_public




Overview
Explore in AI Chat

Overview

MSC_WS_SRP is a PL/SQL package in the APPS schema that supports the Supplier Scheduling and Supplier Release Planning (SRP) functionality within Oracle Advanced Supply Chain Planning (ASCP) in Oracle E-Business Suite. The package exposes web-service-oriented and batch entry points for launching and releasing supplier schedules against a given plan, and for controlling the plan options that govern how SRP processing behaves. Its naming convention (MSC_WS_*) indicates it is a Web Services–facing wrapper package, meaning the underlying business logic is invoked programmatically rather than through an interactive form alone.

The ETRM documentation classifies MSC_WS_SRP with an API classification of OTHER and confirms a VALID status in the APPS schema. Dependency metadata shows the package body operates against global temporary and interface-style tables including MSCGLBDMDSCHTBL, MSCGLBRETURNFCSTTBL, MSCLOCSRPDMDSCHTBL, and MSCLOCSUPSCHTBL, along with the required table type REQTBLTYP. These structures are characteristic of supplier schedule and demand schedule generation, where a PL/SQL table type is used to pass sets of supplier–item–location rows through the release process.

Key Procedures and Functions

The documented API surface consists of six procedures and functions, presented as three public routines paired with corresponding _PUBLIC wrappers:

  • LAUNCH_SRP_BATCH — Initiates the Supplier Release Planning batch run. It drives the schedule generation and release processing for the selected plan, operating over the demand and supplier schedule collections referenced in the dependency list.
  • LAUNCH_SRP_BATCH_PUBLIC — The public wrapper for the batch launch routine, intended for external or web-service callers that must not invoke the internal version directly.
  • RELEASE_SRP — Performs the release of supplier schedules, taking the planned supplier schedule output and committing it for supplier communication.
  • RELEASE_SRP_PUBLIC — The public-facing variant of the release routine, similarly provided as the supported entry point for external invocation.
  • SET_SRP_PLAN_OPTIONS — Establishes or updates the plan-level options that control SRP processing, ensuring the correct plan configuration is applied before launch or release.
  • SET_SRP_PLAN_OPTIONS_PUBLIC — The public wrapper for setting plan options, exposed for web-service and external callers.

The pattern of paired private/public routines is consistent with Oracle's web-service enablement standards, where the _PUBLIC procedure validates context and delegates to the internal implementation.

Tables Accessed

Via APPS synonyms, the package references the following documented tables:

  • MSC_CALENDAR_DATES — Supplies calendar and working-day information used to date supplier schedules and plan buckets.
  • MSC_DESIGNATORS — Provides plan designator definitions, which qualify the plan and organization context for SRP processing.
  • MSC_ITEM_SOURCING — Defines sourcing rules determining which supplier and organization supply each item; central to selecting the correct trading partner for a schedule.
  • MSC_PLANS — The plan definition table, read to validate the plan name and confirm the plan is eligible for SRP release.
  • MSC_PLAN_SCHEDULES — Stores the plan schedule definitions and associated run parameters that govern the launch.
  • MSC_TRADING_PARTNERS — Resolves supplier and customer trading partner records required to address released schedules.
  • DUAL — Standard single-row utility table, used for scalar expressions and validation.
  • PLITBLM — The PL/SQL table of lines mechanism, used internally to hold and iterate over collections of records during processing.

In addition to the synonym-based references, the dependency listing shows direct access to MSCGLBDMDSCHTBL, MSCGLBRETURNFCSTTBL, MSCLOCSRPDMDSCHTBL, and MSCLOCSUPSCHTBL, which hold global and local demand schedule and supplier schedule rows.

Usage Notes

MSC_WS_SRP is typically invoked when a planner or integration process needs to generate and release supplier schedules for an ASCP plan without navigating the full Planning workbench. Because the routines are exposed as public web-service entry points, the package commonly appears in integrations that call LAUNCH_SRP_BATCH_PUBLIC, RELEASE_SRP_PUBLIC, and SET_SRP_PLAN_OPTIONS_PUBLIC in sequence. The documentation records zero dependent packages, so no other PL/SQL unit in the EBS codebase calls this package directly; invocations originate from web service endpoints, concurrent processing, or custom code. When extending or troubleshooting SRP behaviour, the _PUBLIC procedures should be treated as the supported interface, and callers should ensure plan options are set before launch so that the batch and release steps operate against the intended configuration.