Search Results msc_bor_requirements




Overview
Explore in AI Chat

Overview

The MSC_BOR_REQUIREMENTS table is a core data repository within the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) module. It functions as the detailed transactional table for the Bill of Resources (BOR) model. A Bill of Resources defines the set of manufacturing resources, such as machines and labor, required to produce an assembly item within a specific organization. This table stores the individual resource requirement records that collectively constitute a BOR, enabling the planning engine to accurately calculate capacity consumption and schedule production based on resource availability and constraints.

Key Information Stored

The table's structure is designed to link resource requirements to their defining contexts. Its primary key uniquely identifies a requirement record through a combination of PLAN_ID, TRANSACTION_ID, and SR_INSTANCE_ID. Key columns include BILL_OF_RESOURCES, which links to the parent BOR definition in MSC_BILL_OF_RESOURCES, and ASSEMBLY_ITEM_ID, which identifies the item being built. The RESOURCE_ID and DEPARTMENT_ID columns specify the exact resource and its department, linking to MSC_DEPARTMENT_RESOURCES. The ORGANIZATION_ID and SR_INSTANCE_ID columns provide the organizational and sourcing instance context, respectively, ensuring the requirement is correctly scoped within the multi-organization planning model.

Common Use Cases and Queries

This table is central to capacity-constrained planning and resource load analysis. Common use cases include generating detailed resource utilization reports for a specific plan, analyzing the resource footprint of critical items, and validating BOR setups. A typical analytical query would join MSC_BOR_REQUIREMENTS with MSC_SYSTEM_ITEMS and MSC_DEPARTMENT_RESOURCES to list all resource requirements for an assembly, including resource codes and usage quantities. For troubleshooting, planners may query this table to verify that a BOR has been successfully exploded and its component resource requirements loaded into the planning snapshot for a given PLAN_ID and ORGANIZATION_ID.

Related Objects

MSC_BOR_REQUIREMENTS maintains critical foreign key relationships with other central planning tables, as documented in the ETRM:

  • MSC_BILL_OF_RESOURCES: Links via BILL_OF_RESOURCES, PLAN_ID, ORGANIZATION_ID, and SR_INSTANCE_ID. This is the parent table containing the BOR header definition.
  • MSC_SYSTEM_ITEMS: Links via ASSEMBLY_ITEM_ID, PLAN_ID, SR_INSTANCE_ID, and ORGANIZATION_ID. This provides item master details for the assembly.
  • MSC_DEPARTMENT_RESOURCES: Links via PLAN_ID, ORGANIZATION_ID, RESOURCE_ID, SR_INSTANCE_ID, and DEPARTMENT_ID. This relationship validates and provides details on the specific resource within a department.