Search Results msc_form_query_s




Overview
Explore in AI Chat

Overview

APPS.MSC_ANALYSIS_PKG is a VALID package body within the Oracle E-Business Suite APPS schema, associated with the Advanced Supply Chain Planning (ASCP) analytical layer. Its role is to perform the analytical and presentation-layer calculations that support planning dashboards, cost analyses, and service-level reporting in the MSC (Materials/Supply Chain) product family. The package is classified as OTHER under the ETRM API taxonomy, indicating that it is an internal supporting package rather than a formally published integration API. Its documentation confirms that it is not referenced by any database object, meaning it functions as a leaf-level consumer of other MSC packages and tables rather than as a shared library invoked across many dependent modules. In the context of Oracle EBS 12.1.1 and 12.2.2, ASCP relies on this package to translate raw planning data into the aggregated cost figures, service-level breakdowns, and user-specific query preferences that appear in planning forms and analytical reports.

Key Procedures and Functions

The documented interface exposes eleven procedures and functions, all oriented toward retrieving, computing, or preserving analytical data used by planning forms:

Each routine is a read-oriented helper supporting the analytical forms layer. The metadata does not document parameter signatures, so no parameter lists are stated here.

Tables Accessed

The package references tables exclusively through APPS synonyms and relies on DUAL for trivial queries. The documented dependencies include MSC_BIS_INV_DETAIL and MSC_BIS_PERIODS, which supply the business intelligence inventory and period data underlying cost and service-level calculations. MSC_FORM_QUERY and MSC_FORM_QUERY_S store saved query definitions and their associated specifications, which are central to the preference-storage and query-retrieval behavior of STORE_USER_PREF. Planning configuration data comes from MSC_PLANS, MSC_PLAN_ORGANIZATIONS, MSC_SERVICE_LEVELS, MSC_PERIOD_START_DATES, MSC_INTERORG_SHIP_METHODS, and MSC_ITEM_CATEGORIES. Operational master and transactional data are drawn from MSC_SYSTEM_ITEMS, MSC_SUPPLIES, and MSC_TRADING_PARTNERS. The package also delegates to MSC_GET_NAME, MSC_ANALYSIS_PKG itself, and FND_GLOBAL for naming and session-context resolution.

Usage Notes

MSC_ANALYSIS_PKG is typically invoked from ASCP planning forms and analytical concurrent programs rather than from public integration APIs. The presence of STORE_USER_PREF and the MSC_FORM_QUERY_S dependency indicates that the package participates in the form query framework, saving and retrieving user query preferences so that planner selections persist across sessions. Similarly, the GET_* helper functions are called by form-level triggers and region-level queries to resolve plan defaults, service levels, category set IDs, and period counts at runtime. Because the package is not referenced by any database object, it should be treated as a presentation and analysis utility layer; custom code should avoid direct calls unless replicating the form behavior. In 12.2.2 the package remains VALID and its dependency set is unchanged from 12.1.1, making it a stable, if internal, component of the ASCP analytical stack.