Company Type
Zamma, a PE-backed manufacturer of laminate-flooring moldings, trim, and accessories; ORDO master-data engine — the automation that keeps GP and ORDO aligned without administrators.
What Drove the Need
Master data for raw materials and manufactured sub-components changed constantly; manual upkeep could not keep production moving between GP updates
Business Impact
Manual master-data upkeep for raw materials and manufactured sub-components eliminated, and production kept moving between GP updates — part of the ORDO delivery that eliminated over 97% of data issues (Case 28)
Systems/Data Integration
GP item master and lot-controlled inventory upload (10-minute polling)
Design
Scheduled staging-and-merge procedures against the GP2ORDO upload; manual inventory-quantity transaction creation available to prevent production hold-ups between cycles
Technology Stack
Oracle APEX 18.2 / PL/SQL
Scheduled staging and merge procedures
Oracle APEX Scheduled Automated Master Data Creation & Updates
Scheduled staging-and-merge procedures on the 10-minute GP upload create or update locations, bins, item master SKUs, and BOMs and generate, update, or delete GP inventory-quantity transactions for finished and raw-material rolls.
