The True Cost of Bad CMMS Data: Why SAP PM and Maximo Installations Fail Reliability Teams
Charles Duah
Lead Reliability Engineer & Principal Consultant
Mining and power operators in West Africa routinely spend $1.5M to $4M licensing and deploying SAP Plant Maintenance (SAP PM), IBM Maximo, or Mainsaver. Twelve months after go-live, the reliability engineering group still cannot compute a valid Weibull shape parameter (β) or Mean Time Between Failures (MTBF) from the database.
In our diagnostic audits across Ghanaian gold plants and thermal IPPs, 60% to 75% of historical corrective work orders cannot be used for statistical life data analysis. The software works as configured, but the functional location hierarchy and failure reporting schema were built by ERP finance consultants for cost-center accounting rather than ISO 14224 engineering taxonomy.
Share of historical SAP PM / Maximo corrective tickets closed with free-text notes ("Fixed", "Checked OK") or catch-all codes ("OTH - Other") prior to catalog remediation.
Capital tied up in duplicate or obsolete warehouse MRO line items when Bill of Materials (BOM) records are not linked to Maintainable Item tags.
ISO 14224 Equipment Hierarchy & Failure Coding Comparison Table
Fitting a Weibull distribution or Crow-AMSAA reliability growth curve requires separating failure events at the Maintainable Item level (level 7/8 in ISO 14224). Below is the contrast between typical unstructured work-order closeout text and an ISO 14224 4-level boundary and failure code structure:
| Unstructured Work-Order Text | Equipment Class | Subunit | Maintainable Item | ISO 14224 Failure Mode + Mechanism + Root Cause |
|---|---|---|---|---|
| "Mill slurry pump leaking — fixed" | Centrifugal Slurry Pump (PU-310-A, Warman 650) | Shaft Sealing & Bearing Assembly | Gland Packing / Expeller Ring & Shaft Sleeve | Failure Mode: ELP (External Leakage - Process Medium) | Mechanism: 2.3 Wear / Abrasion | Cause: 3.4 Insufficient seal-water flush pressure |
| "Crusher tripped" | Primary Gyratory Crusher (CR-101, Metso Superior MK-III) | Lube & Hydraulic Spider System | Main Lube Return Line & Differential Pressure Switch | Failure Mode: STP (Spurious Stop / Trip) | Mechanism: 5.1 Plugged / Choked | Cause: 4.2 High silica dust ingress past spider dust seal |
| "Generator overtemp alarm, reset" | Gas Turbine Generator Package (GT-201, Solar Titan 130) | Lube Oil Cooling Circuit | Fin-Fan Heat Exchanger Tube Bundle & Louvers | Failure Mode: OHE (Overheating) | Mechanism: 5.2 Fouling / Scaling | Cause: 2.1 Fin bundle fouled by oil mist and harmattan dust |
| "Conveyor belt torn, spliced" | Overland Ore Conveyor (CV-010-TRK, ST-2500 Steel Cord) | Transfer Chute & Impact Idler Station | Top Cover Elastomer & Skirtboard Liner Plates | Failure Mode: BRD (Breakdown / Longitudinal Rip) | Mechanism: 2.1 Mechanical Overload / Cut | Cause: 4.5 Tramp iron / worn chute deflector liner |
Three Operational Consequences of Corrupted CMMS Hierarchies
- Censored Life Data Contamination: When seal replacements, impeller swaps, and motor rewinds are all logged against the parent pump functional location (`PU-310-A`) instead of child maintainable items, calculating pump MTBF mixes three distinct Weibull failure modes and produces meaningless averages.
- Ghost Stockouts & Inflated Warehouse Working Capital: Without structured BOM links between equipment tags and warehouse material numbers, planners order emergency spares by vendor part number while identical SKUs sit unallocated on warehouse shelves.
- High PM Compliance With Rising Breakdown Rates: Sites routinely report 94% Preventive Maintenance (PM) schedule compliance while unplanned mill trips climb, because calendar PM checklists do not measure quantitative condition parameters (mm/s RMS vibration, clearance in mm, or megohm insulation resistance).
CMMS Data Remediation Protocol
Standard 8-to-10 Week SAP PM / Maximo Re-Engineering Scope
- Restrict Catalog Profiles by Equipment Class: Configure SAP PM catalog profiles (Object Part / Damage / Cause / Activity) so a fitter closing a centrifugal pump ticket only sees the 8 to 10 ISO 14224 failure modes applicable to rotating pumps, removing "Other" from the dropdown.
- Rebuild the Functional Location Tree to Maintainable Items: Deconstruct flat cost-center asset lists into ISO 14224 parent-child hierarchies down to the bearing assembly, mechanical seal, instrumentation loop, and drive motor.
- Enforce Mandatory Closeout Validation Rules: Require SMU/operating hour meter readings, down-timestamp start/end, and structured Cause codes before a corrective work order (`PM01` / `CM`) can transition to Technical Completion (`TECO`).
Weibull++ and RGA models are only as accurate as the failure timestamps and suspension flags fed into them. Restructuring your CMMS hierarchy to ISO 14224 turns SAP PM or Maximo from an accounting ledger into an engineering database.