Search Results schedule_details_iv




Overview
Explore in AI Chat

Overview

MSC_ANALYSIS_SAFETY_STOCK_PERF is an APPS-owned PL/SQL package in Oracle E-Business Suite that supports the Inventory Optimization module of Oracle Advanced Supply Chain Planning. Its stated purpose, taken from the package header, is to populate a temporary table with the values displayed by the Inventory Optimization Safety Stock and Service Level report. The package is declared AUTHID CURRENT_USER, so its unqualified references resolve against the invoking schema's privileges, and its header identifies the source revision as MSCIORS.pls 120.1 (2007/04/30), classifying it as an OTHER API rather than a supported public interface.

Functionally, the package serves as the data-preparation layer behind reporting on safety stock and service level performance. It gathers plan, organization, category, item, and customer context, resolves the plan's category set, and materializes analytical results into staging structures that the reporting layer reads. The package is referenced by one other package in the EBS codebase and is therefore an internal dependency of the Inventory Optimization reporting flow rather than a standalone entry point.

Key Procedures and Functions

  • SCHEDULE_DETAILS_SL — produces service-level detail rows. It accepts a query identifier returned to the caller along with period type, plan, organization, category, item, customer, customer class, and ABC classification selectors, reflecting the report's multi-dimensional filtering.
  • SCHEDULE_DETAILS_SS — produces safety-stock detail rows filtered by plan, organization, category, and item.
  • SCHEDULE_DETAILS_IV — produces inventory detail rows driven by period type, plan, organization, category, and ABC classification.
  • SCHEDULE_AGGREGATE — the aggregation routine named in the user's search. It accepts the plan identifier and consolidates analytical results at the aggregate level, driving the MSC_ANALYSIS_AGGREGATE staging table used by the report.
  • GET_CAT_SET_ID — a helper function that returns the category set identifier associated with a given plan, allowing the detail routines to resolve category hierarchies consistently.

The three SCHEDULE_DETAILS_* routines return a query identifier through an OUT NOCOPY parameter, which the calling form or program uses to fetch the staged result set. Each is a distinct procedure; callers invoke the one matching the report view they intend to display.

Tables Accessed

The package reads and writes a focused set of MSC tables through APPS synonyms. Planning context comes from MSC_PLANS, MSC_PLAN_ORGANIZATIONS, MSC_PLAN_BUCKETS, and MSC_PERIOD_START_DATES. Item and classification data come from MSC_SYSTEM_ITEMS, MSC_ITEM_CATEGORIES, and MSC_SAFETY_STOCKS. Demand and partner information is drawn from MSC_DEMANDS and MSC_TRADING_PARTNERS. Staging and query output is written to MSC_ANALYSIS_AGGREGATE, MSC_FORM_QUERY, and MSC_FORM_QUERY_S, while MSC_BIS_INV_DETAIL and MSC_BIS_PERIODS supply inventory and period detail. AD_DDL is referenced for dynamic DDL operations, consistent with the package's use of temporary staging structures.

Usage Notes

This package is invoked from the Inventory Optimization Safety Stock and Service Level report, which supplies the plan, organization, category, item, customer, and ABC parameters and then consumes the staged rows through the returned query identifier. It is not intended for direct customer invocation; the ETRM classification of OTHER and the absence of documented API parameters indicate that signatures may change between releases. Oracle EBS 12.1.1 and 12.2.2 deployments should treat MSC_ANALYSIS_SAFETY_STOCK_PERF as an internal dependency of the Inventory Optimization reporting layer, reachable through its calling form or any custom wrapper that respects the same parameter set and staging-table contract.