Search Results mrp interface




The MR_SIZE_TBL is a critical table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2, primarily associated with the Manufacturing and Planning modules. This table stores size-related attributes for items, which are essential for Material Requirements Planning (MRP), inventory management, and production scheduling. Below is a detailed analysis of its structure, purpose, and usage within Oracle EBS.

1. Table Overview

The MR_SIZE_TBL is a reference table that maintains size-based information for items, enabling organizations to categorize and manage inventory based on dimensional attributes. It is particularly useful in industries where items vary by size, such as apparel, automotive, or construction. The table is part of the Oracle Manufacturing schema and is often referenced in MRP, Inventory, and Product Development modules.

2. Key Columns and Structure

The table typically contains the following columns:
  • SIZE_ID: A unique identifier for each size entry.
  • SIZE_CODE: A user-defined code representing the size (e.g., 'S', 'M', 'L').
  • DESCRIPTION: A textual description of the size.
  • UOM_CODE: The unit of measure associated with the size (e.g., 'INCH', 'CM').
  • ENABLED_FLAG: Indicates whether the size is active (Y/N).
  • START_DATE_ACTIVE and END_DATE_ACTIVE: Define the validity period for the size.
Additional columns may include CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY for auditing purposes.

3. Functional Role in Oracle EBS

The MR_SIZE_TBL plays a pivotal role in:
  • Item Master Setup: Sizes defined in this table are assigned to items in MTL_SYSTEM_ITEMS_B, enabling size-based inventory tracking.
  • MRP and Forecasting: Size attributes are used in demand planning and material requirements calculations.
  • Order Management: Sales orders and purchase orders can reference sizes for accurate fulfillment.
  • Reporting: Enables granular reporting on inventory levels, sales, and production by size.

4. Integration with Other Modules

The table integrates with:
  • Inventory (INV): Links to MTL_ITEM_SIZES for item-size associations.
  • Order Management (OM): Sizes are referenced in order lines (OE_ORDER_LINES_ALL).
  • Product Development: Used in Bills of Materials (BOMs) for size-specific components.

5. Customization and Extensions

Organizations often extend the table by:
  • Adding custom columns (e.g., WEIGHT_PER_SIZE) via descriptive flexfields.
  • Creating size hierarchies for multi-level categorization.
  • Developing custom APIs to automate size assignments.

6. Best Practices

To optimize usage:
  • Standardize size codes to avoid duplication.
  • Use the ENABLED_FLAG to retire obsolete sizes.
  • Leverage indexes on SIZE_ID and SIZE_CODE for performance.

7. Conclusion

The MR_SIZE_TBL is a foundational table in Oracle EBS for managing size-based inventory and planning. Its integration across modules ensures consistency in item categorization, enabling efficient operations in industries where size variations are critical. Proper configuration and maintenance of this table are essential for accurate MRP, inventory control, and order fulfillment.