Search Results msc_full_pegging




The MSC_FULL_PEGGING table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical data structure within the Advanced Supply Chain Planning (ASCP) module. It stores comprehensive pegging information, which represents the relationships between supply and demand elements in a supply chain plan. Pegging is essential for traceability, enabling planners to understand how demand is fulfilled by supply and vice versa. This table is populated during the planning engine's execution and is used extensively for reporting, analysis, and decision-making.

Purpose and Functionality

The primary purpose of MSC_FULL_PEGGING is to maintain a detailed record of pegging relationships across the supply chain. It captures hierarchical dependencies between demand orders (e.g., sales orders, forecasts) and supply orders (e.g., purchase orders, work orders, transfers). This enables end-to-end visibility, allowing planners to perform root-cause analysis, simulate scenarios, and optimize supply chain performance. The table supports both horizontal pegging (direct relationships) and vertical pegging (multi-level dependencies).

Key Columns and Structure

The table contains numerous columns, but the most significant ones include:
  • PLAN_ID: Identifies the specific supply chain plan.
  • TRANSACTION_ID: Unique identifier for the pegging relationship.
  • DEMAND_ORDER_TYPE and SUPPLY_ORDER_TYPE: Specify the types of demand and supply orders (e.g., "Sales Order," "Work Order").
  • DEMAND_ORDER_ID and SUPPLY_ORDER_ID: Foreign keys linking to order details in other tables.
  • ORGANIZATION_ID: Indicates the inventory organization involved.
  • ITEM_ID: References the item being pegged.
  • QUANTITY: The pegged quantity between supply and demand.
  • END_PEGGING_FLAG: Marks terminal nodes in the pegging hierarchy.

Integration with Other Modules

MSC_FULL_PEGGING integrates with several Oracle EBS modules, including Inventory (INV), Order Management (OM), Purchasing (PO), and Manufacturing (WIP). For example:
  • Demand orders may originate from OE_ORDER_HEADERS_ALL (Order Management).
  • Supply orders may link to PO_HEADERS_ALL (Purchasing) or WIP_DISCRETE_JOBS (Work in Process).
The table is also queried by ASCP's Pegging Report and Graphical Workbench to visualize supply-demand relationships.

Technical Considerations

The table is optimized for read-heavy operations, as pegging data is primarily consumed by reporting tools. However, during plan runs, it undergoes significant write activity. Partitioning strategies may be employed in large implementations to improve performance. Indexes on PLAN_ID, TRANSACTION_ID, and ITEM_ID are common to accelerate queries.

Customization and Extensions

While Oracle provides standard pegging logic, customers may extend MSC_FULL_PEGGING for custom requirements, such as:
  • Adding user-defined attributes via descriptive flexfields (DFFs).
  • Developing custom reports using the pegging data.
  • Integrating with third-party analytics tools.

Conclusion

The MSC_FULL_PEGGING table is a cornerstone of Oracle ASCP, providing the foundational data structure for supply-demand visibility and analysis. Its design supports complex supply chain scenarios, enabling organizations to achieve greater agility and responsiveness. Proper understanding and utilization of this table are essential for effective supply chain planning in Oracle EBS 12.1.1 and 12.2.2 environments.