Windchill ConsultingBOM / EBOM5-month engagement
EBOM Integrity Validators and Bulk Data Utilities for BOM Restructuring
An aircraft seating manufacturer had accumulated years of inconsistent EBOM data in Windchill: parts with missing attributes, broken component links, duplicate part numbers across product families, and BOMs that had never been formally validated before release.
Problem
No server-side validation enforced completeness before BOM release. Engineers could promote parts and BOMs with missing weight, material, or drawing references. Over 14,000 parts had at least one missing mandatory attribute.
Solution
Developed a set of server-side Windchill validators using ValueRequired constraints and custom OperationDelegate classes that block BOM promotion when mandatory attributes are absent. Built headless Java data utility scripts for bulk attribute repair, part deduplication, and BOM structure normalization.
Technology
Windchill Java API, OperationDelegate, ValueRequired constraints, WTPart/WTPartMaster subtypes, IBA attribute framework, headless Java batch utilities, Oracle JDBC
14K
Parts cleaned in initial run
0
MES import failures post-deployment
2d→0
Weekly manual repair effort
100%
BOM completeness at release
Working on something similar?
Tell us what you have. In 30 minutes we can tell you whether it is a fit and what it would involve.