Migrating an item master of more than a million inventory items — with categories, VAT and assignment across 18 business units — from Oracle EBS into Oracle Fusion, roughly five times faster than a manual FBDI load.
A million-plus items makes throughput the whole game. Manual FBDI batches don’t scale; Syntra’s pipelined load ran about five times faster and could be re-run cleanly.
Each item had to be assigned to the correct organizations across 18 business units — encoded once in the tool and applied consistently rather than re-derived per run.
Item categories and organization codes did not line up one-to-one with Fusion; these were mapped to Fusion value sets and validated before load.
Per the agreed rule, items flagged inactive in the source were loaded as active in Fusion, handled as a transformation rather than a manual edit.
Item categories, organization codes and VAT categories mapped to the Fusion targets in Syntra.
Organization assignments generated automatically from the encoded business-unit rules.
The 1M+ item master was proven at full volume in the main load runs to confirm throughput before cutover.
Source → staged → Fusion counts and column-level checks confirmed every item and assignment landed.
More than one million inventory items in the item master, plus their categories, VAT categories and organization assignments across 18 business units.
Syntra’s pipelined, validated load ran roughly five times faster than manual FBDI batches, and was safe to re-run because reloads are idempotent.
The 18-BU assignment rules were encoded in the tool and applied consistently to every item, rather than being rebuilt by hand on each run.
Tell us your source EBS footprint, modules and business units — we'll scope a mock-run-based transform-and-load plan on the Syntra ETL platform.