Search Results msc_supplier_pkg




Overview
Explore in AI Chat

Overview

APPS.MSC_SUPPLIER_PKG is an Oracle Advanced Supply Chain Planning (ASCP) package that supports supplier-facing planning analytics. It belongs to the MSC (Master Scheduling / Supply Chain Planning) schema family and is owned by APPS. The package encapsulates supplier spend evaluation, purchase order classification, and supplier detail population logic used by ASCP reporting and planning workflows. Its header revision ($Header: MSCHBSPS.pls 120.3.12010000.2) confirms it was last updated in the 12.1.1 code line and remains present in 12.2.2.

The package provides two categories of functionality: scalar classification functions that evaluate purchase order characteristics (new buy, reschedule, cancellation, spend value), and set-based procedures that populate and purge supplier planning detail and summary staging tables. These operations feed supplier scorecards, capacity analysis, and supply-demand matching within the planning engine.

Key Procedures and Functions

  • POPULATE_DETAILS — A procedure that populates supplier-level planning detail records for a given plan and plan run. It is the primary data-loading entry point, extracting supplier requirements, capacities, and trading-partner information into the MSC_ST_SUPPLIERS_F staging table for downstream processing.
  • SUMMARIZE_SUPPLIERS_F — A function that aggregates staged supplier detail into summarized supplier records, supporting higher-level spend and capacity rollups (MSC_SUPPLIERS_F).
  • EXPORT_SUPPLIERS_F — A function that exports summarized supplier data, typically for external reporting or integration with other planning or procurement systems.
  • IMPORT_SUPPLIERS_F — A function that imports supplier data into the planning schema, enabling supplier capacity or commitment information to be brought into the planning model.

The package specification additionally declares supplier_spend_value, is_new_buy_order, is_rescheduled_po, and is_cancelled_po — functions used to evaluate purchase order disposition based on p_order_type, plan type, purchasing-enabled flags, and reschedule/cancellation indicators. The user search term "p_order_type" corresponds directly to the parameter these functions use to classify PO events (new buy, reschedule, cancel) before supplier spend or requirement records are generated.

Tables Accessed

Usage Notes

MSC_SUPPLIER_PKG is not exposed through a standard Oracle Forms UI; it is invoked indirectly by ASCP planning engine concurrent programs and planning manager workflows. The populate and purge procedures are typically scheduled as part of the plan run lifecycle, while the export/import functions support supplier collaboration and data exchange. Custom code calling the classification functions must supply a valid p_order_type value consistent with ASCP PO disposition coding. The package is referenced by zero other packages in the documented dependency graph, indicating it is a terminal node invoked by concurrent manager jobs rather than a shared utility library.