Oracle Fusion Cloud ERP and Fishbowl integration

What moves between them

The main flow runs from Oracle Fusion into Fishbowl. Purchase orders created in Oracle Fusion are polled and synced into Fishbowl with vendor name and line-item details mapped to Fishbowl vendors and parts. Supplier invoice headers and amounts from Oracle Fusion flow to Fishbowl to match against receiving and provide audit linkage. Vendors are aligned in both directions so a new supplier registered in Oracle Fusion can be matched to an existing Fishbowl vendor or created as a new one. The sync runs on a schedule you define, typically every 5 to 15 minutes, so procurement changes in Oracle Fusion appear in Fishbowl within minutes.

How ml-connector handles it

ml-connector stores both credential sets encrypted. On the Oracle Fusion side, it handles OAuth2 token refresh before expiry and polls the purchase orders and invoices endpoints using LastUpdateDate filters to pull only changed records. On the Fishbowl side, it maintains the session token and maps Oracle supplier IDs and GL account combinations to Fishbowl vendor records and account codes. Vendors are checked before each sync so a vendor in Oracle Fusion either matches an existing Fishbowl vendor by external ID or is created with a default naming convention. Fishbowl is on-premise, so ml-connector accepts the server URL and port per customer, opening network access on your internal network. Purchase order line items are matched to Fishbowl parts by part number or SKU, and if no match is found, a placeholder record is created for manual review. Every record carries a full audit trail showing the source Oracle Fusion transaction, the Fishbowl result, and any mapping or retry events.

A real-world example

A mid-sized discrete manufacturer runs Oracle Fusion Cloud for procurement and accounts payable and Fishbowl Advanced on-premise for inventory, manufacturing orders, and shop floor tracking. Before the integration, the procurement team created purchase orders in Oracle Fusion and re-entered them into Fishbowl by hand, or sent spreadsheets to the warehouse. With Oracle Fusion and Fishbowl connected, each purchase order in Oracle flows automatically into Fishbowl, matched to the correct vendor and part number, and appears in the receiving workflow within minutes of creation. Month-end reconciliation is faster because the inventory and procurement records are already aligned.

What you can do

• •Sync purchase orders from Oracle Fusion to Fishbowl with vendor and line-item details mapped to Fishbowl vendors and parts.
• •Keep supplier records aligned between Oracle Fusion and Fishbowl so new vendors are created or matched automatically.
• •Poll Oracle Fusion and Fishbowl on a schedule tied to your procurement cycle, with retries and a full audit trail on every record.
• •Handle OAuth2 bearer token refresh on the Oracle Fusion side and session token management on the Fishbowl side.
• •Provide a complete audit log of every purchase order and invoice sync so you can trace data back to the source.

Questions

Which direction does data move between Oracle Fusion and Fishbowl?

The main flow is Oracle Fusion into Fishbowl. Purchase orders and supplier invoices move from Oracle Fusion into Fishbowl, with vendors aligned in both directions so a new supplier in Oracle Fusion can be matched to or created in Fishbowl. General ledger account combinations are typically managed in Oracle Fusion, so ml-connector does not write GL accounts into Fishbowl.

Does Fishbowl being on-premise require special network setup?

Yes. Fishbowl runs on a server you control, so ml-connector requires network access to the Fishbowl server at the URL and port you provide. The connection is direct via HTTP or HTTPS on your internal network. You provide the server URL and port as part of the connector configuration.

How does the integration handle Oracle Fusion's lack of direct webhooks?

ml-connector polls both Oracle Fusion and Fishbowl on a schedule you define, typically every 5 to 15 minutes. It uses LastUpdateDate filters on the Oracle Fusion side to pull only changed records, keeping network overhead low while ensuring procurement changes appear in Fishbowl within minutes.