Search Results load_safety_stock

Overview

MSC_CL_OTHER_ODS_LOAD is an Oracle Advanced Supply Chain Planning (ASCP) internal PL/SQL package owned by the APPS schema. It is declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the invoking user rather than the definer. Its role is to load "other" operational data store (ODS) content — reference, planning, and business-intelligence master data that falls outside the primary item, bill-of-material, and sourcing flows — from the E-Business Suite source tables into the MSC (Advanced Planning) staging tables that feed the planning server. The package version header indicates a 12.0.7-level file carried forward into the 12.2.2 code line, so the reference documentation is valid for both 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The documented interface contains 29 procedures, most of which follow a uniform single-purpose naming convention:

• Planning reference data: LOAD_SAFETY_STOCK, LOAD_SOURCING, LOAD_SUB_INVENTORY, LOAD_UNIT_NUMBER, LOAD_PROJECT, LOAD_PLANNERS, LOAD_DEMAND_CLASS, LOAD_SALES_CHANNEL, LOAD_ATP_RULES, LOAD_TRIP, LOAD_DELIVERY_DETAILS, LOAD_VISITS, LOAD_MILESTONES, LOAD_WBS, LOAD_WOATTRIBUTES, LOAD_WO_TASK_HIERARCHY, LOAD_WO_OPERATION_REL, and LOAD_IB_CONTRACTS copy their respective source entities into the planning ODS.
• Business intelligence data: LOAD_BIS_PFMC_MEASURES, LOAD_BIS_TARGET_LEVELS, LOAD_BIS_TARGETS, LOAD_BIS_BUSINESS_PLANS, and LOAD_BIS_PERIODS populate performance-measure and target structures used by BIS-informed planning.
• Calendar and currency: LOAD_FISCAL_CALENDAR builds the planning fiscal calendar; LOAD_CURRENCY_CONVERSION and PURGE_STALE_CURRENCY_CONV manage exchange-rate rows (added for bug 6469722), with the purge removing obsolete conversions.
• Text attributes: LOAD_SHORT_TEXT and LOAD_LONG_TEXT load short and long descriptive text respectively — this pair is the object most often cited when users search for "load_long_text".
• Orchestration: POPULATE_ORG accepts ERRBUF and RETCODE output parameters together with an instance identifier, assignment set identifier, and a complete-refresh flag, allowing a single controlled entry point that drives the full load for an organization or instance.

Tables Accessed

Access is performed through APPS synonyms. Documented targets and sources include MSC_APPS_INSTANCES, MSC_ASSIGNMENT_SETS and MSC_ASSIGNMENT_SETS_S (instance and assignment-set configuration), MSC_ATP_RULES, MSC_CALENDARS and MSC_CALENDAR_MONTHS, MSC_CARRIER_SERVICES, MSC_CATEGORY_SET_ID_LID, MSC_CURRENCY_CONVERSIONS, and the BIS tables MSC_BIS_BUSINESS_PLANS, MSC_BIS_PERFORMANCE_MEASURES, MSC_BIS_PERIODS, MSC_BIS_TARGETS, and MSC_BIS_TARGET_LEVELS. FND_USER is referenced for planner and user identity resolution. In each case the package reads the corresponding EBS source entity and writes or refreshes the matching MSC staging row so the planning engine can consume it during a collection or refresh cycle.

Usage Notes

The package is not intended for direct end-user invocation. It is called from Oracle's planning collection programs and internally by other MSC packages — the metadata records one referencing package — during a complete or targeted data refresh. LOAD_LONG_TEXT and LOAD_SHORT_TEXT execute as part of that broader collector run rather than standalone. POPULATE_ORG is the documented programmatic entry point and is called with the instance and assignment-set identifiers plus the complete-refresh indicator. In 12.1.1 and 12.2.2, custom code should invoke these procedures only inside an approved collection execution context, since they assume the planning schema and concurrent-manager environment are already initialized. Because the package runs with AUTHID CURRENT_USER, callers must hold the necessary privileges on the underlying APPS synonyms. The PURGE_STALE_CURRENCY_CONV procedure should be scheduled in step with the currency conversion load to avoid stale exchange-rate data.