Duplicate Material Codes for Mining Equipment Spare Parts: Types, Causes and Governance

Duplicate material codes, where one spare part has several codes in an ERP system, fragment stock and lead to repeat purchases, yet why they persist in maintenance spare parts is poorly understood. This paper treats duplication as a failure of item identification and distinguishes three layers of material attributes: identity (manufacturer part number), description (name, language, format, unit) and application (host equipment). Using 10,396 mobile equipment spare parts codes from a nickel–cobalt mine in Papua New Guinea, part-number screening found 250 duplicate groups covering 5.0% of codes, 97% of which split stock across codes. Three mechanisms were identified. First, descriptions diverge so widely that an exact name match would detect only 6% of the groups, against 92% for the part number as recorded. Second, 48% of the groups span different equipment groups, showing that coding by host equipment repeatedly recodes common parts. Third, duplicates accumulate over time and are more frequent where descriptions mix languages. Governance should therefore use the part number as the identity key, standardise descriptions, and record host equipment as a where-used link rather than as grounds for a new code.

Authors

Institutions

Publication Details

Journal
European Journal of Engineering and Technologies
Published
2026-10-26
DOI
https://doi.org/10.71222/akrf8n82
Primary Topic
Data Quality and Management
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Duplicate Material Codes for Mining Equipment Spare Parts: Types, Causes and Governance

Qiangqiang Xu, Lusen Zhang, Congcong Wu, Pinggeng Chen et al.
European Journal of Engineering and Technologies
Data Quality and Management
article

Duplicate Material Codes for Mining Equipment Spare Parts: Types, Causes and Governance

Qiangqiang Xu, Lusen Zhang, Congcong Wu, Pinggeng Chen, Zhe Zhang
article en

Abstract

Duplicate material codes, where one spare part has several codes in an ERP system, fragment stock and lead to repeat purchases, yet why they persist in maintenance spare parts is poorly understood. This paper treats duplication as a failure of item identification and distinguishes three layers of material attributes: identity (manufacturer part number), description (name, language, format, unit) and application (host equipment). Using 10,396 mobile equipment spare parts codes from a nickel–cobalt mine in Papua New Guinea, part-number screening found 250 duplicate groups covering 5.0% of codes, 97% of which split stock across codes. Three mechanisms were identified. First, descriptions diverge so widely that an exact name match would detect only 6% of the groups, against 92% for the part number as recorded. Second, 48% of the groups span different equipment groups, showing that coding by host equipment repeatedly recodes common parts. Third, duplicates accumulate over time and are more frequent where descriptions mix languages. Governance should therefore use the part number as the identity key, standardise descriptions, and record host equipment as a where-used link rather than as grounds for a new code.

European Journal of Engineering and TechnologiesVol. 2(5)
Divine Word University (PG)
Openalex Percentile: Top 10%
Data Quality and Management
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon
Duplicate Material Codes for Mining Equipment Spare Parts: Types, Causes and Governance — Qiangqiang Xu, Lusen Zhang, et al. · European Journal of Engineering and Technologies (2026) | TGRS Research Map | TGRS