Pre-built infor cloudsuite healthcare data migration for Financials, Supply Chain, HCM and Process Manufacturing. Lawson S3 database extractors, ION BOD replay, OS Portal REST exports, FBDI/HDL emitters, row-level reconciliation. Audit-ready SOX + HIPAA evidence at every load.
The hard part isn't running SELECT against Lawson tables. It's translating Infor's 30-year data model into Fusion's modern shape without losing the GL → AP → PO → receipt audit chain or the Joint Commission HCM documentation.
Infor CloudSuite Healthcare is Lawson S3 — the dominant healthcare ERP since the 1990s — wrapped in CloudSuite and hosted on AWS via Infor Cloud. The data model is wide and deep: 9,000+ tables across Financials, Supply Chain and HCM; an accounting-unit hierarchy that captures hospital/clinic/department/cost-center structure in a single dimension; GPO contracts with tier pricing four levels deep; Lawson's HRHISTORY audit log that records every HR transaction over 20+ years.
Oracle Fusion's data model is fundamentally different. The COA is a 6-segment structure (typically Company, BU, Cost Center, Account, Product, Future). Workers sit in a global HCM core with location-driven legal-entity routing. Items use UNSPSC + supplier-managed classifications. Every infor cloudsuite healthcare data migration to Fusion has to bridge those gaps without breaking the audit chain — or the Joint Commission license and competency documentation that surveyors will demand on the next visit.
Syntra ETL replaces multi-month bespoke conversion development with pre-built crosswalks refined across dozens of Infor migrations. The same engine handles three deployment scenarios: full Infor replacement onto Fusion, phased pillar-by-pillar migration (Financials first, then Supply Chain, then HCM), and the multi-instance consolidation where four Infor tenants merge onto one Fusion tenant during a post-M&A integration program.
The transformations Syntra ETL ships pre-built. No custom SQL backfill, no multi-month bespoke conversion development per pillar.
Lawson accounting-unit hierarchies (often 5–7 levels deep) walked, classified by reporting role, and routed: facility levels collapse to Fusion BUs, department levels to Cost Center segment, sub-unit to Future segments. Crosswalk versioned and signed.
Multi-instance employee dedupe by SSN/EIN/employee-id with conflict resolution. Payroll YTD balances reconstructed from PAYHIST and loaded via HDL Balance Adjustment with cent-level reconciliation.
ITEMMAST conflicts across instances resolved with single master designation; site cross-references preserved. UNSPSC/NDC/HCPCS clinical coding carried through. GPO contract tier eligibility preserved.
CTRHEADER/CTRTIER 4-level GPO contract hierarchies (Premier, Vizient, HealthTrust) converted to Fusion Procurement Contracts with tier-up commitments, admin-fee splits and rebate accrual schedules preserved.
In-flight ION business documents captured at cutover and replayed into Fusion via OIC adapters. Critical clinical interfaces (Epic, Cerner, GHX) sequenced so no transaction is dropped or duplicated.
License records, competency assessments, mandatory training history, position-control linkages migrated with full audit timeline. Surveyors see continuous evidence across the Infor-to-Fusion boundary.
A repeatable load order that respects Fusion's data dependencies. Skip a step and your AP invoice load fails on missing suppliers or your payroll load fails on missing element definitions.
Fusion enterprise structures, ledgers, BUs, COA segments, calendars, currencies, payroll legislative data, HCM organizations configured. Loaded via FSM tasks — not user-facing data, but everything downstream depends on it.
Workers (HDL Worker.dat), suppliers (FBDI Supplier Import), customers (FBDI Customer Import), items (FBDI Item Import with UNSPSC/NDC/HCPCS), GL accounts, projects, fixed-asset categories. Loaded in dependency order — never invoices before suppliers.
Open AP invoices and payments, open AR invoices and receipts, open POs and requisitions, open requisition approvals, in-process payroll cycles. Migrated in transactional state with reference to closed history.
Closed GL periods loaded via FBDI Journal Import with full sub-ledger detail. Trial balances reconciled to the cent vs Lawson. AP/AR aging reconciled at customer/supplier/BU level. Fixed-asset depreciation history loaded.
HRHISTORY audit log loaded for SOX/HIPAA continuity. Payroll YTD balances loaded via HDL Balance Adjustment. Benefits enrollments, garnishments, license records loaded. Joint Commission documentation timeline validated.
Final delta replay via ION BOD subscriptions, parallel-month and parallel-payroll reconciliation, sign-off pack issued (trial balance, AP/AR aging, payroll register, item perpetual — Infor vs Fusion to the cent). Production cut to Fusion.
Every Infor data domain emits to the exact FBDI/HDL/REST format Fusion expects. No custom load programs, no rejected-record triage in production.
GL history via Journal Import; opening trial balance via Trial Balance Import; sub-ledger detail preserved for audit drill-down. Reconciled at period/ledger/BU level.
AP Invoice Import, Payment Import, Hold Import. AR Invoice Import, Receipt Import, Adjustment Import. Open and closed transaction state preserved with full document attachments.
AMASSET and AMDEPRSCHED converted to Mass Additions interface. Healthcare-specific depreciation methods preserved. Asset retirement and transfer history loaded.
Supplier Import with tax-id dedupe. Item Import with UNSPSC/NDC/HCPCS coding. Procurement Contract Import with GPO tier hierarchy preserved.
Worker.dat for employees and contingent workers, Element Entry for payroll history, Balance Adjustment for YTD payroll balances. Joint Commission license + competency records preserved.
Post-cutover delta replay via Fusion REST APIs. Critical ION integrations re-implemented as OIC flows. Real-time reconciliation continues for the parallel-run window.
Infor cloudsuite healthcare data migration is the end-to-end movement of structured data from Infor's CloudSuite Healthcare suite (built on Lawson S3) into Oracle Fusion ERP and HCM. Scope spans Financials (GL/AP/AR/Fixed Assets/Cash), Supply Chain (Procurement, Inventory, GPO Contracts), HCM (Workforce Management, Payroll, Benefits, Talent) and Process Manufacturing for in-house pharma operations. The technical heart is direct Lawson S3 database extraction (Oracle or DB2 backing tables), ION BOD replay for in-flight transactions, and Infor OS Portal REST exports for security context. Syntra ETL handles all three with pre-built extractors, governed crosswalks for accounting-unit to Fusion COA, supplier/employee/item dedupe, and Oracle-validated FBDI and HDL output.
Migration is the end-to-end project (extract + transform + load + reconcile + cutover); conversion is the transformation layer specifically. Syntra ETL's infor cloudsuite healthcare data migration engine ships pre-built conversion rules for accounting-unit to Fusion COA segment translation, Infor company/process-level structures to BU/ledger mapping, Lawson item master to Fusion item with UNSPSC/NDC/HCPCS coding preserved, CTRHEADER/CTRTIER GPO contract tiers to Fusion Procurement Contracts, Lawson PAEMPLOYEE/PAYHIST payroll history to HDL payroll balance load, and HRHISTORY audit-log preservation. On a consultant-led project these conversions eat 3–6 months of bespoke SQL and stored-procedure development per pillar.
Lawson S3 sits on Oracle or DB2 underneath the CloudSuite layer. Syntra ETL ships read-only stored procedures and table-aware extract scripts covering all 9,000+ Lawson tables — GLAMOUNTS, GLCONTROL, APINVOICE, APDISTRIB, ARCUSTOMER, AMASSET, POHEADER, ITEMMAST, EMPLOYEE, PAYHIST and the rest. The extractor honours Lawson's natural keys (Company + Accounting Unit + Account for financials; Company + Employee for HCM), preserves the distinctive RW/RH audit columns Lawson uses for change tracking, and streams to Parquet partitioned by company and fiscal year with hash-signed manifests. Extraction runs throttled against a read-only replica when available so live Infor operations are untouched.
Yes — and it's the most common shape. A health system that grew via acquisitions ends up with three or four Infor CloudSuite Healthcare instances plus residual EBS and Workday landscapes. Syntra ETL's multi-source mode extracts from every Infor instance in parallel, runs supplier dedupe by tax-id and address fuzzy match, harmonizes overlapping accounting-unit codes to a unified Fusion COA, resolves item master conflicts (same SKU on three instances with three different prices), and merges HCM employee records where staff have moved between facilities. Output: one clean Fusion tenant carrying the full enterprise history with site-specific cross-references preserved for audit.
Syntra ETL emits Fusion-native load formats for every Infor data domain: FBDI Journal Import for GL history, FBDI Trial Balance Import for opening balances, FBDI AP Invoice and Payment Import, FBDI AR Invoice and Receipt Import, FBDI Fixed Asset Import (Mass Additions), FBDI Supplier Import, FBDI Customer Import, FBDI Item Import, FBDI Procurement Contract Import, HDL Worker.dat for employees, HDL Element Entry for payroll history, HDL Balance Adjustment for YTD payroll balances. Every payload is validated against the current Oracle Fusion 26x release schema before submission, so validation errors surface locally — not in a 4-hour Fusion ESS job that fails on row 487,000.
Every record extracted from Lawson S3 is hashed at the source. Every record loaded into Fusion is re-hashed post-load. The reconciliation engine compares counts (journals, invoices, employees, items), sum totals (debit/credit per ledger per period, AP open per BU per currency, payroll gross/net per pay period) and hash signatures per company per period. Any record that fails Fusion validation is captured with the exact field-level reason ready for bulk fix. Output is a signed timestamped reconciliation pack: Infor trial balance vs Fusion trial balance to the cent, AP aging vs aging, payroll register vs register, item perpetual inventory vs Fusion item quantities. Internal audit signs off on the pack directly — no spreadsheet reconciliations.
Yes. After the initial bulk load, Syntra ETL captures Infor deltas through ION BOD subscriptions plus Lawson RW/RH-column watermarks and replays into Fusion via REST APIs and FBDI. This supports the standard parallel-run pattern: Infor continues taking transactions for 1–2 month-end cycles (and 2 payroll cycles) while Fusion is validated to the cent. Once finance, supply chain, HR and clinical operations sign off, new transactions cut to Fusion and Infor moves to read-only archive mode. Critical clinical interfaces (Epic charge posting, Cerner pharmacy charge feeds, GHX EDI) are migrated in lockstep so no clinical workflow is broken at cutover.
SOX requires 7-year retention of financial records with auditable trace from GL entry back to original supporting evidence. HIPAA federal rules require 6-year retention; many states (California, Texas, New York) require 7–30 years for healthcare records. Syntra ETL's infor cloudsuite healthcare data migration preserves the full chain: Fusion GL line → AP invoice → PO → requisition → receipt → original vendor document, with every hop signed and timestamped. Where Fusion is the cutover target, full transactional history loads into Fusion. Where the operational window only justifies 2–3 years in Fusion, older history routes to a long-term cloud archive — queryable for audit during the full SOX/HIPAA/state retention period with the same evidence chain intact.
Book a 30-minute discovery call. We'll walk through your Infor instances, Lawson customization profile, GPO contract complexity, payroll YTD reconciliation requirements and reporting rebuild scope — and give you a concrete data-migration plan before the call ends.