Search Results msc_cl_cont_coll_fw




Overview
Explore in AI Chat

Overview

MSC_CL_CONT_COLL_FW is an Oracle Applications (APPS) PL/SQL package belonging to the Advanced Supply Chain Planning (ASCP) module of Oracle E-Business Suite. The suffix "FW" denotes a framework package, and "CONT_COLL" identifies its scope as continuous collections within the MSC (Material Planning / Supply Chain) schema. Its principal responsibility is to determine and initialize the refresh type applied to individual planning entities during a data collection run. Continuous collection allows ASCP to refresh planning data incrementally rather than performing a full refresh, and this package encapsulates the decision logic that classifies each entity as a snapshot entity, a non-snapshot entity, or an entity requiring targeted refresh based on collection thresholds, collection frequency, and organizational scope.

Key Procedures and Functions

The package exposes three documented entry points:

  • INIT_ENTITY_REFRESH_TYPE — An initialization procedure invoked at the start of a collection cycle. It evaluates collection threshold and frequency parameters alongside the last targeted continuous collection timestamp to derive refresh-type flags for each planning entity category. The output parameters cover entity families including bill of material, bill of resources, item, on-hand, user-defined supply and demand, sales order, forecast, WIP, supplier capacity, purchase order, master demand schedule, master production schedule, non-snapshot entities, supplier replenishment, and trip data. This procedure establishes the per-entity snapshot/non-snapshot posture that governs downstream collection behavior.
  • SET_CONT_REFRESH_TYPE — A Boolean-returning function that computes the refresh type for a supplied instance and task number, returning the applicable continuous collection refresh mode and, via an out parameter, the associated continuous last refresh number (LRNN). It forms a core decision point for the continuous collection framework.
  • SET_CONT_REFRESH_TYPE_ODS — The ODS (Operational Data Store) variant of the refresh-type entry point. It parallels SET_CONT_REFRESH_TYPE in purpose but is scoped to ODS-based continuous collection processing, allowing the framework to apply equivalent refresh classification logic against the operational data store source.

Tables Accessed

The package references four tables through APPS synonyms:

  • FND_LOOKUP_VALUES — Provides reference lookup data used to validate or resolve collection-related configuration values.
  • MSC_APPS_INSTANCES — Holds registered application instance definitions, used to identify the source instance participating in the collection cycle.
  • MSC_INSTANCE_ORGS — Maps instances to their associated organizations, supporting organization-scoped collection decisions.
  • DUAL — Used for scalar evaluations and PL/SQL expression resolution.

Usage Notes

This package is an internal framework component rather than a public API; ETRM classifies it as "OTHER." It is invoked indirectly by the ASCP continuous collection infrastructure, typically from the collection manager concurrent programs and from other MSC collection packages — the metadata records two dependent packages that reference it. It is not intended for direct invocation from Oracle Forms or custom code. The header comment dates the specification to April 2007 ($Header revision 120.1), reflecting the pre-12.1 lineage retained through EBS 12.1.1 and 12.2.2. Customizations should avoid override, as changes may break collection refresh determination across all ASCP plans.