Search Results need_recompare

Overview

MSC_NETCHANGE_PKG is an Oracle Advanced Supply Chain Planning (ASCP) package body owned by APPS and classified under ETRM as an OTHER API. Its primary business function is to support the "Compare Plans" capability within Oracle EBS Supply Chain Planning. It computes the net change between two plans — a source plan and a target plan — and produces both an option comparison and an exception comparison, allowing planners to identify what changed in supply, demand, resources, and constraints before committing to a revised plan.

The package declares several package-level globals, including g_yes and g_no (varchar2(10)), g_from_plan, g_to_plan, g_cat_set, g_cat_set_name, g_options_query_id, g_excp_query_id, and flags such as g_need_insert_temp and g_long_query. Integer constants NOT_COMPARED (1), IN_PROGRESS (2), NEED_RECOMPARE (3), and AVAILABLE (4) govern plan comparison state. Customer-facing queries for the "g_yes" flag typically map to these localized yes/no labels used in comparison criteria and filtering logic within the package.

Key Procedures and Functions

The package exposes nineteen documented procedures and functions organized around three concerns: orchestration, dimension-specific comparison, and exception handling.

• COMPARE_PLANS — Top-level entry point. Accepts source and target plan identifiers, an options flag, folder id, exception list, and criteria id, and returns option and exception query ids via out parameters.
• COMPARE_OPTIONS, COMPARE_AGGREGATE, COMPARE_OPTIMIZE, COMPARE_ORGS, COMPARE_SCHEDULES, COMPARE_CONSTRAINTS, COMPARE_GOALPROG — Dimension-specific comparators for options, aggregate resources, optimization, organizations, schedules, constraints, and goal programs.
• COMPARE_EXCEPTIONS, COMPARE_ALL_EXCEPTIONS, COMPARE_EACH_EXCEPTION, POPULATE_ALL_EXCEPTIONS — Manage exception-level comparison, populating and iterating through exception detail records.
• FILTER_DATA — Applies selection criteria filters to the comparison data set.
• CONVERT_CONDITION — Translates stored criteria conditions into executable query predicates.
• CALCULATE_START_DATE — Computes the effective start date for plan comparison windows.
• CHECKPLANSTATUS, COMPARE_PLAN_NEED_REFRESH — Determine whether plans are in a comparable state or require refresh/recompilation.
• CATEGORY_NAME — Resolves a category set identifier to its display name.
• PURGE_PLAN — Removes transient comparison data for a plan.

Tables Accessed

The package reads and writes through APPS synonyms. MSC_PLANS, MSC_NET_CHANGE_CRITERIA, MSC_CRITERIA, and MSC_FORM_QUERY / MSC_FORM_QUERY_S drive comparison configuration and query definitions. MSC_ASSIGNMENT_SETS, MSC_CATEGORY_SETS, and MSC_DESIGNATORS resolve planning categories and item/resource scope. MSC_DEMANDS, MSC_FULL_PEGGING, MSC_EXCEPTION_DETAILS supply supply/demand and exception source data. Working and result tables — MSC_NEC_COMPARE_PLANS, MSC_NEC_COMPARE_PLANS_S, MSC_NEC_EXC_DTL_COMPARE, and MSC_NEC_EXC_DTL_TEMP — store intermediate and final comparison output.

Usage Notes

MSC_NETCHANGE_PKG is invoked primarily from the ASCP "Compare Plans" concurrent program and associated OAF/Forms UI where planners select source and target plans, exception categories, and folder-based selection criteria. It is referenced by one other package, indicating it participates in a larger planning utility chain rather than being called directly by customers. Because it writes into MSC_NEC_* staging tables, concurrent program invocations should be serialized per plan set to avoid contention. Customizations should avoid direct calls and instead reuse the documented COMPARE_PLANS signature or invoke the underlying concurrent program, since internal globals such as g_yes, g_options_query_id, and g_excp_query_id are session-scoped and not reentrant.