GUIDEWIRE FUSION INTEGRATION

    Guidewire Oracle Fusion Integration — Real-Time and Batch

    Continuous guidewire fusion integration for P&C insurers. Bidirectional flow, near-real-time premium recognition, real-time claim payment push, reserve sync patterns, bordereaux cycle preservation. Hybrid real-time + batch per data domain.

    5-15 min
    Near-real-time latency
    Bidirectional
    Forward + reverse flow
    Per-domain
    Cadence configurable
    Multi-consumer
    Beyond Fusion alone

    What guidewire fusion integration actually delivers — beyond one-shot migration

    A migration moves data once. An integration keeps two systems aligned continuously. The guidewire fusion integration is what keeps Fusion's GL reflecting the truth of what Guidewire is doing in real time — not catching up at end-of-month with a 3-day batch.

    P&C carriers operating Guidewire and Oracle Fusion need more than a one-shot migration — they need a continuous data flow that keeps Fusion aligned with whatever PolicyCenter, BillingCenter and ClaimCenter are doing right now. New policies bound in the last hour need to show in Fusion's written-premium GL today. Claim payments authorised this morning need to be in Fusion AP this afternoon. Receipts cleared yesterday need to be in Fusion AR by start-of-business today. The guidewire fusion integration delivers all of this continuously, with configurable cadence per data domain matching business need, and with bidirectional reconciliation feedback so neither system drifts from the other.

    The architecture supports hybrid real-time + batch flow per domain. Real-time paths use Guidewire Cloud Messaging events captured as they fire, transformed via crosswalk, pushed to Fusion via REST API within 5-15 minutes — used for high-value premium recognition, claim payment push, and treasury cash position. Batch paths use Cloud Data Access (CDA) incremental Parquet exports batched hourly or end-of-day, transformed via crosswalk, loaded via FBDI bulk loaders — used for high-volume small-ticket personal lines flows where higher throughput is preferred over lower latency. Reverse flow paths use Fusion event streams captured back into Guidewire via Cloud Messaging — used for payment-clearance status, cash-application correction, and supplier-master sync.

    The integration is multi-consumer by design. Fusion is one downstream consumer of Guidewire data — but most P&C carriers also feed an actuarial data warehouse, a BI platform, regulatory reporting tools, fraud detection systems and reinsurance broker portals. The Syntra ETL extraction layer feeds all consumers from a unified canonical event stream — a single CDA + Cloud Messaging extraction supports Fusion plus all the others. This eliminates the operational burden of running five separate extraction pipelines hitting Guidewire independently — and reduces the load on the Guidewire production environment to a single read-only consumer.

    The four flow patterns supported by guidewire fusion integration

    1
    Real-time forward (Guidewire → Fusion)
    5-15 minute latency. Event-driven via Cloud Messaging. Used for claim payment push, near-real-time premium recognition, treasury cash position.
    2
    Batch forward (Guidewire → Fusion)
    Hourly to end-of-cycle. CDA Parquet + FBDI bulk load. Used for high-volume small-ticket personal lines, ceded reinsurance bordereaux cycles.
    3
    Real-time reverse (Fusion → Guidewire)
    5-15 minute latency. Used for payment-clearance status to ClaimCenter, bank-reconciled receipt status to BillingCenter, suspense-account correction.
    4
    Batch reverse (Fusion → Guidewire)
    Hourly to end-of-cycle. Used for supplier-master sync, customer-master sync, end-of-period reconciliation pack closure.

    Six core guidewire fusion integration patterns

    These are the patterns Syntra ETL ships pre-built. No bespoke event-stream coding, no hand-built REST orchestration, no quarterly Fusion-release rebuild.

    Near-real-time premium recognition

    Large commercial policies bind in PolicyCenter; event captured via Cloud Messaging; pushed to Fusion Revenue Recognition within 5-15 minutes; written-premium GL posted same business day.

    💸

    Real-time claim payment push

    Adjudicator authorises ClaimCenter payment; event captured; claimant supplier created/verified in Fusion; AP Invoice pushed via REST; payment-ready status returned to ClaimCenter.

    📊

    Reserve sync as evidence metadata

    Reserve changes captured via Cloud Messaging; transformed to Fusion evidence metadata payloads; pushed to paid-loss GL records as supplementary attributes; archived for actuarial.

    🔁

    Bordereaux cycle preservation

    Ceded premium + ceded recovery batched per bordereaux cycle per treaty; transformed to Ceded GL + Reinsurer AR/AP; loaded via FBDI; reconciled to the cent; pack delivered to broker.

    💳

    Cash position + payment clearance sync

    BillingCenter receipts pushed hourly via FBDI Receipt Import + AutoMatch; bank-reconciled cleared-status returned to BillingCenter; treasury sees same-day cash position.

    👥

    Supplier + customer master sync

    Claimants + producers + reinsurers synced to Fusion Suppliers via Supplier Import; policyholders synced to Fusion Customers; bidirectional updates preserved across systems.

    A continuous guidewire fusion integration day-in-the-life

    How the integration actually behaves across a 24-hour cycle. Operators see status at each stage on the unified dashboard.

    1

    00:00 — End-of-day batch close — Midnight

    Previous-day's full activity batched via CDA — premium, claim payments, cash receipts, commission disbursements. FBDI submissions queued for overnight load to Fusion.

    2

    00:30-05:00 — Overnight FBDI loads — Overnight

    FBDI Journal Import for GL, AP Invoice Import for claim payments + commissions, Receipt Import + AutoMatch for cash, Supplier Import for new suppliers. ESS lifecycle tracked, errors recovered.

    3

    05:00 — Overnight reconciliation — Pre-business

    Row-level reconciliation pack generated for overnight batch. Variance > 0.01 per LOB per state surfaced to operator dashboard for triage before business open.

    4

    06:00-22:00 — Real-time intraday flow — Business hours

    ClaimCenter payment events, PolicyCenter bind events, BillingCenter receipt events captured continuously via Cloud Messaging; pushed to Fusion within 5-15 minutes.

    5

    Hourly — Hourly batch top-up — Per hour during business

    Hourly CDA delta extract for any data domain configured for hourly cadence (premium, cash, claim payments). FBDI submission cycles within 60 minutes of extract.

    6

    22:00-00:00 — Pre-close prep — Pre-midnight

    Reverse-flow updates from Fusion to Guidewire (payment-clearance status, bank-reconciled cash status, supplier-master sync). End-of-day reconciliation pack generation.

    The unified extraction layer — one pipeline, many consumers

    The guidewire fusion integration is one consumer of the Syntra extraction layer. Other consumers subscribe to the same canonical event stream with no additional Guidewire load.

    🏦

    Oracle Fusion Financials

    The primary consumer for this integration — premium to revenue, paid-loss to GL, claim payments to AP, cash to AR, ceded reinsurance to ceded GL. Fusion-native FBDI + REST.

    📊

    Actuarial data warehouse

    Subscribes to claim, payment, reserve and exposure topics for loss-development triangle reconstruction, IBNR estimation, statutory reserve calculation. Pull-mode consumer.

    📈

    BI / analytics platform

    Subscribes to written-premium, paid-loss, claim-frequency, claim-severity topics for management reporting, segment analytics, loss-ratio dashboards. Streaming consumer.

    ⚖️

    Regulatory reporting

    Subscribes to NAIC Schedule P, Schedule F, State Page 14 topics for statutory filing generation. Triggered consumer aligned to filing calendar.

    🕵️

    Fraud detection (SIU)

    Subscribes to claim, payment, party-link topics for SIU red-flag detection, network-analysis, claimant-cross-reference. Streaming consumer with model-trained alerts.

    🤝

    Reinsurance broker portals

    Subscribes to ceded premium, ceded recovery, treaty bordereaux topics for broker reporting. Bordereaux-cycle-aligned consumer with broker-format output (XML, CSV, JSON, Lloyd's MRC).

    Frequently asked questions

    What is a guidewire fusion integration and how does it differ from a one-shot migration?+

    A guidewire fusion integration is the ongoing, continuous data flow between Guidewire InsuranceSuite (PolicyCenter, BillingCenter, ClaimCenter) and Oracle Fusion Financials — not a one-time migration. Where a migration runs once to move historical data, an integration runs continuously to keep the two systems aligned: new policies issued in PolicyCenter flow to Fusion as revenue recognition source transactions; new claim payments in ClaimCenter flow to Fusion as AP invoices and paid-loss GL journals; new receipts in BillingCenter flow to Fusion as AR receipts; reinsurance cessions flow as ceded GL postings and reinsurer AR/AP entries. The guidewire fusion integration supports both real-time and batch patterns per data domain with bidirectional reconciliation feedback.

    How does real-time vs batch integration work in a guidewire fusion integration?+

    The integration architecture supports both per data domain. Real-time / near-real-time (5-15 minute latency) uses Guidewire's Cloud APIs and event streams to push individual transactions to Fusion via REST API — used for claim payments (treasury needs same-day cash position) and high-value premium issuances (large commercial accounts wanting same-day revenue recognition). Batch (hourly to end-of-cycle) uses Cloud Data Access (CDA) Parquet exports and FBDI bulk loaders — used for high-volume small-ticket flows (personal auto premium, homeowners claim payments) where 1-hour latency is acceptable and FBDI's higher throughput is preferred. Most P&C carriers run a hybrid — some domains real-time, others batch — and the guidewire fusion integration supports both simultaneously without operational duplication.

    Can the guidewire fusion integration be bidirectional?+

    Yes — and bidirectional flow is required for several P&C scenarios. Forward (Guidewire → Fusion): premium, paid-loss, cash, commissions, ceded reinsurance flow downstream. Reverse (Fusion → Guidewire): treasury-confirmed payment status returns to ClaimCenter so adjudicators know when a claim payment cleared; bank-reconciled cash receipts return to BillingCenter so producer ledgers reflect cleared status; Fusion-side suspense-account resolution returns to BillingCenter for cash-application correction. The reverse flow typically uses Fusion's REST API + event streams paired with Guidewire's Cloud Messaging API to keep the two systems aligned. The guidewire fusion integration supports both forward and reverse with full reconciliation feedback so no flow is fire-and-forget.

    How does near-real-time premium recognition work in the integration?+

    Near-real-time premium recognition handles the case where large commercial accounts (large property schedules, complex commercial liability) are issued in PolicyCenter and need immediate revenue recognition in Fusion — sometimes within the same business day. The integration flow: PolicyCenter event fires on policy bind; Syntra ETL captures the event via Guidewire Cloud Messaging; transforms to Fusion Revenue Recognition source transaction; pushes via Fusion REST API within 5-15 minutes; Fusion's Revenue Recognition module kicks off earning-schedule calculation; written-premium GL posting happens within the same close period. Critically the upstream PolicyCenter policy lifecycle is unaffected — the event fires on bind regardless of whether Fusion is up, and the integration handles back-pressure (if Fusion REST is unavailable the event is queued and pushed when service resumes).

    How does claim payment push work in real-time?+

    Claim payment push is the highest-volume real-time flow in most P&C integrations. The flow: adjudicator authorises a payment in ClaimCenter; ClaimCenter event fires on payment-issue; Syntra ETL captures the event via Guidewire Cloud Messaging; checks Fusion for existing claimant supplier (creates if needed via Supplier REST API); transforms to AP Invoice via crosswalk; pushes via Fusion AP Invoice REST API; Fusion AP Open Invoice Validation runs; payment-ready status returned to ClaimCenter via Cloud Messaging reverse flow. Total latency typically 5-15 minutes from adjudicator authorisation to Fusion AP. The integration handles claimant-supplier-creation dependency automatically so the adjudicator never sees an error — the supplier is created at the right point in the flow without operator intervention.

    How do reserve sync patterns work in the guidewire fusion integration?+

    Reserves are NOT posted as Fusion financial transactions — but they DO need to be reflected in Fusion for actuarial reporting roll-up. The reserve sync pattern: ClaimCenter reserve change events captured via Cloud Messaging; transformed to Fusion evidence metadata payloads; pushed to Fusion paid-loss GL records as supplementary attributes (ReserveAmount, ReserveDate, ReserveUser, ReserveReason); also pushed to the long-tail Parquet archive partitioned by claim per coverage per accident-year for actuarial loss-triangle reconstruction. Fusion's GL itself is unchanged — paid-loss GL accounts only show actual paid-loss; reserve information is supplementary metadata on those records. The guidewire fusion integration ensures the reserve metadata is current — actuaries querying Fusion always see the latest reserve balance per claim per coverage.

    How does the guidewire fusion integration handle reinsurance bordereaux?+

    Reinsurance bordereaux cycles are typically monthly or quarterly per treaty. The integration flow: ceded premium accrued in PolicyCenter per policy per treaty per layer is batched per bordereaux cycle; ceded loss recovery accrued in ClaimCenter per claim per treaty per layer is batched per bordereaux cycle; at bordereaux cycle close, Syntra ETL extracts the cycle data from Guidewire; transforms to Fusion Ceded GL postings + Reinsurer AP/AR entries via crosswalk; loads via FBDI Journal Import for the GL postings and FBDI AP/AR Invoice Import for the reinsurer entries; reconciles the cycle per treaty per reinsurer to the cent; produces the bordereaux pack for delivery to the broker. The bordereaux cycle is preserved unbroken through the integration — treaty settlements never fail because of integration timing issues.

    Can the guidewire fusion integration coexist with other downstream consumers — data warehouse, BI, regulatory reporting?+

    Yes. The guidewire fusion integration is one of several downstream consumers of Guidewire data — most P&C carriers also feed an actuarial data warehouse, a BI / analytics platform, regulatory reporting tools, fraud detection systems and reinsurance broker portals. The Syntra ETL extraction layer is multi-consumer by design: a single CDA + Cloud API extraction feeds all downstream consumers from a unified canonical event stream. Fusion is one consumer; the data warehouse is another; BI tools subscribe to specific topics; regulatory reporting subscribes to the regulatory-relevant subset. This eliminates the consultant-led pattern where each downstream consumer has its own bespoke extraction pipeline — five extraction pipelines for five consumers, all hitting Guidewire independently with five times the operational burden.

    Ready to architect your guidewire fusion integration?

    Book a 30-minute discovery call. We will walk through your per-domain real-time vs batch requirements, your bidirectional flow needs, your bordereaux cycle calendar and your multi-consumer extraction landscape — and have your integration architecture sketched before the call ends.