Purpose-built integration for duck creek to oracle fusion migration. Both Duck Creek OnDemand (SaaS) and Duck Creek Platform supported. Policy / Billing / Claims financial events transformed into Fusion AR / AP / GL with full insurance audit context preserved. NAIC statutory reporting compatible.
Duck Creek runs P&C insurance operations. Fusion runs finance, HCM and supply chain. Replacing one with the other is not viable. Integrating them properly is the project that pays back.
Duck Creek Technologies, acquired by Vista Equity Partners in 2023, is the dominant Guidewire competitor in P&C insurance core — Policy, Billing, Claims, plus increasingly Insights for analytics. Carriers in personal lines, commercial lines, specialty and E&S all run Duck Creek as the system of record for insurance operations. Oracle Fusion, in contrast, is a general-purpose ERP — strong on GL, AR, AP, fixed assets, procurement, HCM and project accounting, but with no native concept of a policy term, a claim feature, a reserve, a treaty cession or a NAIC Annual Statement line. Replacing Duck Creek with Fusion is not a project that any P&C carrier has ever attempted to a successful conclusion.
What carriers actually want from a duck creek to oracle fusion migration is finance modernization while leaving insurance operations on Duck Creek. The legacy AR and AP systems that sit downstream of Duck Creek — often PeopleSoft, EBS, Lawson or a homegrown finance stack from a 1990s acquisition — get retired and replaced with Fusion. The integration layer between Duck Creek and Fusion is the actual project: extract every premium, commission, claim payment, reserve adjustment and reinsurance cession from Duck Creek; transform into Fusion-native AR invoices, AP invoices, GL journals; reconcile at the policy and claim level monthly; preserve full insurance audit context for state regulators and external auditors.
Syntra ETL provides the duck creek to oracle fusion migration integration layer. Pre-built Duck Creek extractors for both OnDemand REST APIs and Platform DCSB/SQL connections. Governed crosswalks from Duck Creek line-of-business codes to Fusion COA segments. Insurance-finance translation rules for unearned premium, loss reserves, IBNR, salvage, subrogation and reinsurance cession. NAIC-compatible reporting templates so the Annual Statement, Schedule F and state filings continue to function unchanged after Fusion goes live.
The six things that turn a typical insurance-finance integration into an 18-month consulting engagement.
Written premium earns daily over the policy term. Cancellation, endorsement and reinstatement all reshape the curve. Syntra ETL ships the insurance-finance translation layer that turns Duck Creek policy events into Fusion GL postings with the right daily earning.
Case reserves and IBNR move independently of paid claims. Fusion needs both the paid AP entries and the monthly reserve journals reconciled to the cent against Duck Creek's claim ledger.
Every ceded premium and loss-ceded entry must pair to its originating policy or claim per the treaty configuration. NAIC Schedule F reporting depends on this lineage being intact across the integration.
Duck Creek line-of-business and state codes need governed mapping to Fusion COA segments to preserve state-and-line reporting for NAIC Annual Statement Pages 14 and 15.
Many carriers run both deployments — OnDemand for new books, Platform for legacy. The integration normalizes financial events across both before they reach Fusion, so reporting stays consistent.
Annual Statement, Schedule F, quarterly state filings continue to function unchanged after Fusion goes live. Syntra ETL ships OTBI subject areas tuned for statutory accounting principles (SAP) alongside GAAP.
A repeatable, governed workflow built for P&C insurance integration. Typical full-scope timeline: 22–34 weeks.
Discovery workshop with CFO, controller, actuarial, treasury and IT. Inventory of Duck Creek deployments (OnDemand, Platform, both), lines of business, state footprint, reinsurance treaty registry, current finance system being retired. Per-line premium-earning method confirmed. Fusion COA design walkthrough. Sized assessment with risk register.
Line-of-business to COA segment mapping, state-and-LOB combinations to Fusion ledger structure, claim-feature codes to Fusion expense categories, treaty registry to Fusion AR/AP supplier-customer setup, reserve types to Fusion GL accounts. Insurance-finance translation rules signed off by controller, actuarial and reinsurance leads.
Duck Creek OnDemand API and/or Platform DCSB/SQL extractors deployed. Historical premium, commission, claim payment, reserve adjustment and reinsurance cession data extracted to a staging layer as Parquet partitioned by fiscal period, line of business and state. Signed manifests per partition.
Crosswalks applied, insurance-finance translation rules executed, Fusion FBDI Receivables, Payables and GL Journal payloads generated, validated against Fusion 26x templates. Reserve, unearned-premium and reinsurance calculations validated against the actuarial team's source-of-truth.
FBDI ZIPs submitted to Fusion ESS. AR, AP and GL balances reconciled at the policy and claim level against Duck Creek source-of-truth. Variances surfaced with row-level diagnostics. Statutory reports (Annual Statement, Schedule F) recreated against the Fusion-loaded data and compared to Duck Creek-originated versions.
1–2 month-end cycles in parallel (legacy finance system + Fusion), deltas captured and replayed, reconciled to the cent. Statutory close completed against Fusion. Legacy finance system frozen. Duck Creek-to-Fusion integration enters steady-state operation with monthly reconciliation cadence.
No bespoke API integration. Just configure scope, run, reconcile.
Bind, endorsement, cancellation, reinstatement, renewal — every policy-transaction that affects written or earned premium. Pulled via OnDemand Policy API or Platform DCSB.
Premium-due, payment-receipt, NSF reversal, write-off, return-premium, agency commission. Pulled via OnDemand Billing API or Platform DCSB. Routed to Fusion AR FBDI.
Indemnity payment, loss-adjustment-expense payment, case-reserve adjustment, salvage recovery, subrogation recovery, claim-close. Routed to Fusion AP and GL with claim-feature context.
Case reserves per claim feature, IBNR per actuarial segment, unearned-premium reserves per policy, loss-adjustment-expense reserves. Monthly journals to Fusion GL.
Ceded premium per treaty per bordereau period, loss-ceded entries paired to originating losses, reinstatement premium, profit commission. Routed to Fusion AR/AP per NAIC Schedule F lineage.
Line-of-business codes, state ratebook configurations, treaty registry (proportional, excess-of-loss, facultative), producer registry, claim adjuster registry — exported as crosswalk inputs for the Fusion COA design.
A duck creek to oracle fusion migration is rarely a replacement project — Duck Creek Policy, Billing and Claims are P&C insurance core systems, and Oracle Fusion is enterprise finance, HCM and supply-chain. The real shape of a duck creek to oracle fusion migration is downstream finance integration: Duck Creek Billing premiums, commissions and adjustments flow into Fusion Receivables and Fusion GL; Claims indemnity and loss-adjustment-expense payments flow into Fusion Payables; Duck Creek Policy unearned-premium reserves and IBNR estimates roll into Fusion Financial Reporting; and reinsurance recoverables move into Fusion AR as receivables from cedants. The migration is the modernization of the finance back-end while Duck Creek OnDemand (SaaS) and Duck Creek Platform continue to operate the core insurance value chain. Syntra ETL handles every Duck Creek financial event — policy bind, endorsement, cancellation, premium-due, payment-receipt, claim-payment, salvage-recovery, subrogation-recovery — and emits Fusion-native FBDI Receivables, Payables and GL Journal payloads with full insurance audit context preserved.
A typical Duck Creek Billing-to-Fusion AR integration covering a multi-state P&C insurer with 10+ years of premium and commission history runs 14–22 weeks. A full duck creek to oracle fusion migration covering Billing AR, Claims AP, Policy unearned-premium reserves and reinsurance recoverables runs 22–34 weeks. The acceleration over consultant-led programs comes from pre-built Duck Creek extractors that already understand Duck Creek's domain model (Policy header, term, transaction, transaction-detail, account, billing-account, claim, claim-feature, claim-payment, reserve), governed crosswalks between Duck Creek line-of-business codes and Fusion COA segments, and StatPro-compliant statutory reporting handoffs for NAIC Annual Statement preparation. Insurance carriers with reinsurance ceded books, multi-line products or significant E&S volume routinely add 2–4 weeks for the cedant accounting reconciliation.
Duck Creek Technologies, acquired by Vista Equity Partners in 2023, is a category-leading P&C insurance core platform with deep functionality around policy lifecycle, multi-state ratebook administration, claims workflow and reinsurance cession. Replacing it with a generic ERP is not viable — Oracle Fusion has no Policy module, no Claims module, no rating engine, no statutory reporting for NAIC. The proper architecture is Duck Creek as the system of record for insurance operations and Oracle Fusion as the system of record for finance, HCM and supply-chain, with a governed integration layer between them. Syntra ETL provides that integration layer: Duck Creek financial events captured in near-real-time through the Duck Creek Insights API and OnDemand event streams, transformed into Fusion-native postings with audit trail preserved, reconciled at the policy and claim level monthly. Carriers get the best of both — Duck Creek's insurance core expertise plus Fusion's modern finance, AI-enabled FP&A and integrated HCM.
Both Duck Creek OnDemand (the SaaS deployment, Duck Creek's strategic platform) and Duck Creek Platform (the licensed on-premises or private-cloud deployment that most large carriers still run for their primary books). For OnDemand, Syntra connects through the OnDemand REST APIs (Policy API, Billing API, Claims API, Insights API) with OAuth2 client credentials and event-stream subscriptions for near-real-time financial event capture. For Platform, Syntra connects through Duck Creek's Service Bus (DCSB) and direct SQL Server / Oracle DB read replicas for bulk historical extracts. Carriers running hybrid deployments — OnDemand for new lines of business, Platform for legacy books — get one unified integration layer that normalizes financial events across both deployments before they flow to Fusion.
P&C premium accounting under NAIC statutory rules is materially different from generic ERP revenue recognition. Each policy carries a written-premium amount that earns over the policy term (typically 12 months) per a daily pro-rata or 24ths-method calculation; unearned-premium reserves are computed monthly and reported to state insurance regulators; cancellations trigger return-premium calculations on a short-rate or pro-rata basis; endorsements mid-term trigger additional or return premium. Fusion's vanilla revenue recognition does not handle this natively. Syntra ETL's duck creek to oracle fusion migration handles it through a dedicated insurance-finance translation layer: Duck Creek's policy-transaction events (bind, endorsement, cancellation, reinstatement) drive the calculation; unearned-premium reserves post to Fusion GL as monthly journals with policy-level drill-back; written, earned and unearned premium are reportable per state, per line of business and per producer for NAIC Annual Statement preparation.
Yes. Duck Creek Claims is the source of three Fusion-bound financial flows: indemnity payments to claimants (Fusion AP), loss-adjustment-expense payments to adjusters, defense counsel and vendors (Fusion AP), and case-reserve adjustments that post to Fusion GL as monthly loss-reserve journals. IBNR (Incurred But Not Reported) reserve estimates from your actuarial team layer on top, also posting to Fusion GL. Salvage and subrogation recoveries reverse the original loss postings when collected. The duck creek to oracle fusion migration captures every claim financial event with full claim-feature context (coverage type, peril, accident date) preserved as Fusion DFFs for downstream actuarial and reinsurance reporting. Carriers running multi-line P&C books with property, auto, GL, workers' comp and specialty lines get one consistent claims-to-finance handoff regardless of line.
Reinsurance is one of the highest-risk areas in any insurance finance migration because cedant accounting touches both AR (recoverables from reinsurers) and AP (premium ceded to reinsurers) plus the GL (loss-ceded entries paired to each loss-paid entry). Duck Creek typically holds the treaty configuration (proportional, excess-of-loss, facultative, treaty period, retention, cession percentage) and computes the cession at the transaction level. Syntra ETL extracts every ceded-premium transaction and every loss-ceded transaction with the originating treaty ID, cedant identifier and bordereau period, and emits Fusion AR invoices (for recoverables) and AP credit memos (for ceded premium) with full reconciliation back to the originating Duck Creek policy or claim. NAIC Schedule F (reinsurance ceded) reporting is supported through dedicated OTBI subject areas that combine Duck Creek treaty metadata with Fusion AR/AP balances.
No. The integration runs as a read-only consumer of Duck Creek financial events — no writes ever flow from Fusion back to Duck Creek Policy, Billing or Claims. Underwriters continue binding policies, billing analysts continue managing accounts, claims adjusters continue handling losses on Duck Creek without any change to their workflow. The financial events generated by their work flow through the Insights API or DCSB event stream into a staging layer, get transformed into Fusion-native postings, and land in Fusion GL/AR/AP per the policy schedule (typically near-real-time for cash and bordereau transactions, end-of-day for journal aggregations, monthly for reserve and unearned-premium calculations). The duck creek to oracle fusion migration cutover is the moment the Fusion side goes live with reconciliation against Duck Creek — Duck Creek itself never has a downtime window.
Book a 30-minute discovery call with our P&C insurance-finance integration team. We'll walk through your Duck Creek deployment (OnDemand, Platform or both), line-of-business footprint, state exposure, reinsurance program and the legacy finance system being retired — and give you a concrete timeline and budget before the call ends.