Company Type
Zamma, a PE-backed manufacturer of laminate-flooring moldings, trim, and accessories; ORDO output module for shop-floor execution (samples on file).
What Drove the Need
Operators needed printed work orders, labels, and pick lists that matched the application's data exactly — no re-keying, no Excel
Business Impact
Shop-floor execution and material picking ran from prints and barcoded labels generated directly from application data — no re-keying, no Excel — as part of the ORDO delivery that eliminated over 97% of data issues and resolved major material shortages (Case 28)
Systems/Data Integration
Part of ORDO; prints from live work-order, allocation, and inventory data
Design
Word templates with embedded cursor merge tags populated from nested PL/SQL cursors at print time
Slit-plan grid by profile type, width, slit count, required/extra/short LF, URGENT flagging, and a shaded operator completion section; label per slit width carrying color, customer group, SKU, width, length, and date
Technology Stack
Oracle APEX 18.2 / PL/SQL
APEX Office Print (AOP) — Word templates with cursor merge tags
Oracle APEX On-Demand Work Order, Labels & Inventory Reports with Barcoding
On-demand generation of slitter work-order prints with a slit-plan grid, one barcoded sub-component label per slit width, roll bin pick lists, and nested finished-roll shortage reports.
