Search Results load_setup_transition

Overview

MSC_CL_BOM_ODS_LOAD is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Advanced Supply Chain Planning (ASCP) collection process. Its role is to load bill of material (BOM) and bill of resources (BOR) data from the operational source system into the MSC (Advanced Planning) staging and operational data store tables, collectively referred to as the ODS (Operational Data Store). These loads populate the planning engine with the manufacturing structures that drive supply, demand, and capacity planning calculations.

In EBS 12.1.1 and 12.2.2, the package executes as part of a family of collection programs (designated by the "CL" prefix) that move data from source application tables into the MSC tables used by ASCP and other planning modules. The package is classified as OTHER in the API classification scheme, meaning it is an internal collection utility rather than a public, documented integration API. Its status is VALID, and it is documented in the ETRM repository.

Key Procedures and Functions

The ETRM metadata documents ten procedures or functions within the package, each responsible for a specific class of BOM or resource data:

• LOAD_BOM — Loads bill of material header records into the MSC planning structures.
• LOAD_BOM_COMPONENTS — Loads the component lines associated with each bill of material.
• LOAD_COMPONENT_SUBSTITUTE — Loads component substitute definitions used during planning substitutions.
• LOAD_BOR — Loads bill of resources records, the resource requirements associated with a manufactured item.
• LOAD_RESOURCE_SETUP — Loads resource setup information used in capacity computations.
• LOAD_RESOURCE_CHARGES — Loads resource charge rates applied during cost and capacity planning.
• LOAD_RESOURCE — Loads resource master records.
• LOAD_RES_INST_CHANGE — Handles changes to resource instances over time.
• LOAD_PROCESS_EFFECTIVITY — Loads process effectivity records that define the effective date ranges for process structures.
• LOAD_SETUP_TRANSITION — Loads setup transition data utilized in sequence-dependent planning.

These procedures are invoked collectively by the collection process to produce a consistent snapshot of manufacturing structures in the ODS.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms: MSC_BILL_OF_RESOURCES, MSC_BOMS, MSC_BOM_COMPONENTS, MSC_BOR_REQUIREMENTS, MSC_BOR_REQUIREMENTS_S, MSC_COMPONENT_SUBSTITUTES, MSC_DEPARTMENT_RESOURCES, MSC_DEPT_RES_INSTANCES, MSC_DEPT_RES_INSTANCES_S, MSC_PROCESS_EFFECTIVITY, MSC_PROCESS_EFFECTIVITY_S, MSC_RESOURCE_GROUPS, MSC_RESOURCE_SETUPS, MSC_COLL_PARAMETERS, and MSC_ITEM_ID_LID. The "_S" suffix tables typically hold entity-specific or source-level records, while MSC_COLL_PARAMETERS supplies the runtime collection parameters that scope the load. MSC_ITEM_ID_LID serves as an item identifier cross-reference between source and planning identifiers.

Usage Notes

MSC_CL_BOM_ODS_LOAD is not designed for direct invocation by end users or external applications. It is called by higher-level collection packages. The ETRM metadata explicitly states that it is referenced by MSC_CL_BOM_ODS_LOAD, MSC_CL_COLLECTION, MSC_CL_SETUP_ODS_LOAD, and MSC_CL_WIP_ODS_LOAD, indicating orchestration through the ASCP data collection framework. It does not reference any database object directly outside the dependency list, and it is referenced by three other packages, underscoring its role as a subordinate load routine.

Typical execution occurs during the "Load Planning Data from Sources" or equivalent collection concurrent program, where the collection manager drives the package to refresh BOM and BOR ODS content before the planning engine runs. Custom code should avoid invoking the package independently, since correct operation depends on collection parameters and sequencing established by MSC_CL_COLLECTION. Support analysis of ASCP collection failures should therefore begin at the collection manager level rather than at individual load procedures.