I’ll provide a comprehensive solution covering BOM-CAD synchronization, MCO workflow automation, and revision control to resolve your stuck MCOs and prevent future occurrences.
Root Cause Analysis:
Your MCO workflow has three critical gaps:
- No validation that CAD check-in processing is complete before BOM sync
- BOM sync activity not properly configured to update references
- No pre-release validation to catch revision mismatches
Solution Part 1: Fix Workflow Automation
Add these activities to your MCO workflow template in this sequence:
Activity 1: CAD Processing Wait (Robot)
// Pseudocode - Wait for CAD processing completion:
1. Get all CAD documents affected by this MCO
2. For each CAD document, check worker queue status
3. If any workers still processing, wait 60 seconds and recheck
4. Timeout after 30 minutes with error notification
5. Once all processing complete, advance to next activity
// See: Windchill Workflow Guide Section 12.3
Activity 2: BOM-CAD Synchronization (Robot)
Configure custom robot that:
- Queries all WTPart objects on the MCO resulting items
- For each part, retrieves associated CAD document
- Checks if BOM references match current CAD revision
- If mismatch detected, updates BOM link to latest released CAD revision
- Logs all updates for audit trail
Activity 3: Pre-Release Validation (Robot)
Add validation gate that verifies:
- All BOM items reference current CAD revisions
- No pending CAD worker jobs exist
- All affected items are in releasable lifecycle states
If validation fails, workflow returns to previous activity with detailed error report.
Solution Part 2: Revision Control Configuration
Update your preference settings:
wt.part.usesLatestConfig=true
wt.workflow.validateBOMReferences=true
wt.mco.enforceCADSync=true
These settings ensure:
- BOMs automatically reference latest released revisions
- Workflow validates references before state transitions
- MCO release requires explicit CAD synchronization confirmation
Solution Part 3: Fix Your 15 Stuck MCOs
Immediate remediation steps:
- Identify Mismatches:
Run this query to find all BOM-CAD discrepancies:
SELECT mco.number, part.number, bom_cad.revision, current_cad.revision
FROM mco_affected_items
WHERE bom_cad.revision != current_cad.revision
- Bulk Update Script:
Create utility to update BOM references for all stuck MCOs:
- Read MCO list (15 items)
- For each MCO, get affected BOM items
- Update BOM links to reference latest CAD revisions
- Log changes for compliance
- Restart workflow from sync activity
- Verification:
After updates, verify each MCO:
- Open BOM structure view
- Confirm CAD revision matches latest released version
- Check workflow can proceed past sync activity
- Complete release process
Solution Part 4: Prevent Future Issues
Implement CAD Check-in Hooks:
Add event listener that triggers when CAD documents are checked in:
- Identifies associated MCOs
- Flags MCO for BOM review
- Sends notification to change manager
- Updates MCO status to indicate pending BOM sync
Add User Guidance:
Create workflow instructions that appear when engineers add CAD to MCO:
- “Ensure CAD check-in completes before advancing MCO workflow”
- “Verify BOM references updated after CAD revision”
- “Contact change management if sync errors occur”
Implement Monitoring:
Set up daily reports showing:
- MCOs with pending CAD processing
- BOM-CAD revision mismatches
- Workflow activities waiting on sync
- Failed synchronization attempts
Best Practices for BOM-CAD Synchronization:
- Timing Control: Always wait for CAD worker completion before BOM operations
- Revision Policies: Define clear rules for which CAD revision BOMs should reference (latest released vs. latest iteration)
- Validation Gates: Add multiple validation checkpoints throughout workflow
- Error Handling: Provide clear error messages and recovery procedures
- Audit Trail: Log all BOM updates for compliance and troubleshooting
MCO Workflow Automation Recommendations:
- Use robot activities for all system operations (no manual steps for sync)
- Implement timeout handling for long-running CAD processing
- Add rollback capability if sync fails mid-process
- Create workflow variables to track sync status and attempt count
- Configure email notifications for sync failures
Revision Control Standards:
- Establish policy: BOMs always reference latest RELEASED CAD revision
- Exception handling: If no released revision exists, flag for manual review
- Version tracking: Maintain history of BOM-CAD linkage changes
- Lifecycle alignment: Ensure CAD and BOM items progress through states together
This comprehensive solution addresses all three focus areas and will resolve your stuck MCOs while preventing future synchronization failures. Implementation typically takes 3-5 days including testing.