Search Results p_cat_set_id

Overview

MSC_DS_SCHEDULE (MSCDSSB.pls, version 120.0) is a PL/SQL package body owned by APPS within the Oracle EBS Advanced Supply Chain Planning (ASCP) module. It supplies the data-access layer behind the planning "Schedule" or exception-summary reporting views, aggregating counts of planning exceptions and order action recommendations for a given plan. The package belongs to the OTHER API classification, meaning it is not a public, supported integration API but rather an internal implementation body invoked by the planning workbench and related reporting components.

The user's search term p_cat_set_id corresponds directly to a formal parameter of GETSCHEDULESUMMARY. This parameter identifies the category set used to group planning items; the package applies it through NVL(category_set_id, p_cat_set_id) = p_cat_set_id predicates so that exceptions and orders without an explicit category set fall into the caller-supplied default set.

Key Procedures and Functions

The package exposes five documented programs:

• GETSCHEDULESUMMARY — Returns aggregate exception and order-action totals for a plan. It accepts a plan identifier, the category set identifier, and a recommendation-days window, and returns counts for late supply, resource constraints, material constraints, excessive setups, orders to be rescheduled (in and out), and orders to be released.
• GETLATESUPPLYDETAILS — Returns the line-level detail underlying the late supply exception, complementing the summary count produced by GETSCHEDULESUMMARY.
• GETLATESUPPLYSUMMARY — Returns the summarized late supply figures, typically rolled up by category set or plan.
• GETRESUTILSUMMARY — Returns summarized resource utilization information for the plan.
• GETRESUTILDETAILS — Returns the detailed resource-load rows that support the utilization summary.

The body's GETSCHEDULESUMMARY logic is driven by two cursors. c_exc_summary queries MSC_EXCEPTION_DETAILS_V for exception types 87 (Late Supply), 36 (Resource Constraint), 37 (Material Constraint), 90 (Excessive Setups), and 6/7 (Orders to be Rescheduled In / Out), grouping by exception type. c_release counts orders in MSC_ORDERS_V with source table MSC_SUPPLIES, order type 3, unreleased status, matching the category set, and a new order date within the plan start date plus recommendation days. The loop maps each exception type to its corresponding OUT parameter and sums the reschedule counts.

Tables Accessed

• MSC_EXCEPTION_DETAILS_V — Source for exception-type counts used by GETSCHEDULESUMMARY and the late supply programs.
• MSC_ORDERS_V — Source for planned order and release counts, filtered by plan, source table, order type, and release status.
• MSC_PLANS — Supplies plan_start_date and recommendation days for the release-date window.
• MSC_BIS_PLAN_SUMMARY_KPI — Supports plan-level KPI summary reporting.
• MSC_BIS_RES_SUMMARY — Backs the resource utilization summary and detail programs.
• MSC_DEPARTMENT_RESOURCES — Provides department-level resource definitions used in resource utilization calculations.
• PLITBLM — Oracle Applications standard temporary/logging table.

Usage Notes

MSC_DS_SCHEDULE is an internal planning package. It is referenced by zero other packages in the documented metadata, indicating it is called directly by Oracle Supply Chain Planning screens and concurrent programs rather than by other PL/SQL APIs. Interactive use occurs through the ASCP Planner Workbench, where users view schedule summaries by category set; the p_cat_set_id parameter allows the workbench to filter or align exceptions to a specific category set. In custom extensions, the package may be invoked from concurrent programs or wrapper packages that need programmatic exception counts for a plan, but because it is not a published API, signatures and behavior are subject to change across patch levels. It is supported at both EBS 12.1.1 and 12.2.2.