Search Results items




The GR_ITEM_EXPLOSION_PROPERTIES table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical data structure within the Inventory and Bill of Materials (BOM) modules. It stores configuration properties for item explosion processes, which are essential for generating multi-level BOM hierarchies, cost roll-ups, and material requirement planning (MRP) calculations. This table acts as a parameter repository, controlling how items are exploded during BOM inquiries, costing, and planning operations.

Key Functional Areas

The table primarily supports:
  • BOM Explosion: Defines rules for single/multi-level BOM expansions
  • Cost Rollup: Stores parameters for cost calculation methodologies
  • Engineering Change Management: Controls revision effectivity handling
  • Planning: Configures MRP explosion behavior

Table Structure

The GR_ITEM_EXPLOSION_PROPERTIES table typically contains these key columns:
Column Name Data Type Description
EXPLOSION_ID NUMBER Primary key identifier
ORGANIZATION_ID NUMBER Inventory organization reference
EXPLOSION_TYPE VARCHAR2 BOM/ENG/COST/PLAN explosion type
EFFECTIVITY_DATE DATE Control date for revision processing
ALTERNATE_BOM_DESIGNATOR VARCHAR2 Alternate BOM selection criteria
COST_TYPE_ID NUMBER Links to CST_COST_TYPES for cost rollups

Technical Implementation

The table is accessed through these key APIs:
  • BOM_EXPLOSION_PUB package for BOM processing
  • CST_COST_PUB for cost rollup operations
  • MRP_EXPLOSION_PUB for planning explosions

Integration Points

The table integrates with:
  • BOM_BILL_OF_MATERIALS for component data
  • MTL_SYSTEM_ITEMS_B for item attributes
  • CST_ITEM_COSTS for cost calculations
  • MRP_FORM_QUERY for planning outputs

Customization Considerations

When extending functionality:
  • New explosion types require inserts with unique EXPLOSION_TYPE values
  • Custom columns must maintain referential integrity with standard tables
  • API overrides should preserve core validation logic

Performance Implications

Critical indexes include:
  • Composite index on (ORGANIZATION_ID, EXPLOSION_TYPE)
  • Single-column index on EFFECTIVITY_DATE
  • Foreign key indexes for all reference columns

Upgrade Impact

Between 12.1.1 and 12.2.2:
  • Column additions for cloud integration in 12.2.2
  • New explosion types for advanced supply chain features
  • Enhanced security through VPD policies in 12.2.2

Best Practices

  • Maintain explosion properties at organization level when possible
  • Standardize explosion types across implementations
  • Archive historical explosion parameters separately