ml-connector
Oracle E-Business SuiteAvidXchange

Oracle E-Business Suite and AvidXchange integration

Oracle E-Business Suite runs procurement, payables, and the general ledger. AvidXchange handles invoice capture, approval routing, and payment execution by check, ACH, and virtual card. Connecting the two lets vendors and GL coding flow from EBS into AvidXchange so AP staff can code and approve invoices, and the settled payment detail flows back into EBS without re-keying. ml-connector handles the very different APIs on each side and moves the records on a schedule you control.

How Oracle E-Business Suite works

Oracle E-Business Suite exposes suppliers, purchase orders, AP invoices, AP payments, and GL code combinations through Integrated SOA Gateway REST services that an administrator deploys from the Integration Repository, each under a customer-chosen service alias on a customer-hosted hostname and port. Calls authenticate with HTTP Basic Auth or a session token cookie and must carry operating-unit and responsibility context on every request. Reads come from open interface views; most writes insert into an open interface table and then need a concurrent program such as Payables Open Interface Import to post. EBS has no self-service webhooks, so records are read by polling open interface views filtered on last update date.

How AvidXchange works

AvidXchange exposes vendors, invoices with line-level GL coding, purchase orders for matching, GL accounts and accounting dimensions, and settled payments through the AvidConnect REST API in JSON. Authentication uses proprietary tokens rather than standard OAuth2: a customer generates a Company Token and a User Token inside AvidSuite, and the partner tier uses client credentials. Vendors, GL codes, and invoices are written into AvidXchange from the accounting system, while payment results are read back; GL accounts and dimensions are read-only on the AvidXchange side. There is no public webhook, so payment status is pulled on a schedule after a batch is submitted.

What moves between them

Two directions. From Oracle E-Business Suite into AvidXchange, ml-connector pushes vendor master records and GL code combinations so invoices can be coded and routed to valid payees and accounts, then submits approved or validated AP invoices, including the PO reference for matching. From AvidXchange back into Oracle E-Business Suite, it pulls settled payment records, the check number, ACH trace, or virtual-card detail, and stages them so the ledger reflects what AvidPay actually paid. Vendors and GL codes sync first as reference data; invoices then payments follow on a cadence tied to your AP cycle. Approval routing stays inside AvidXchange, so only the resulting status and payment come back.

How ml-connector handles it

ml-connector stores both credential sets encrypted. On the EBS side it logs in for a session token, sends it as a cookie, and attaches the operating-unit and responsibility context on every call, re-authenticating when EBS returns 401 on an expired session. On the AvidXchange side it sends the Company and User tokens on each request. Vendors and GL code combinations are synced first, because a missing vendor in AvidXchange means a payment cannot be routed and an unknown GL code blocks coding. Invoices are submitted as a batch and the connector polls the AvidXchange payment endpoint for status, since there is no webhook on either side. Writing payments back into EBS uses the open interface table, so a 200 from EBS means the row was staged, not posted, and the connector confirms the concurrent program ran before marking the record complete. EBS has no rate limiter and no idempotency key, so ml-connector keeps concurrency low to protect the shared instance and sets the interface SOURCE column plus a natural key to detect duplicate payments. Every record carries a full audit trail and can be replayed if a downstream call fails.

A real-world example

A mid-sized property management firm of roughly four hundred staff runs Oracle E-Business Suite for procurement and payables across several legal entities and uses AvidXchange to capture and pay supplier invoices. Before the integration, AP clerks re-keyed vendor changes and GL codes into AvidXchange by hand, exported approved invoices to a file, and typed settled check and ACH detail back into EBS at month-end, which left the payables ledger lagging the bank and prone to duplicate or mis-coded entries. With Oracle E-Business Suite and AvidXchange connected, vendors and GL codes stay current in AvidXchange, approved invoices submit automatically, and settled payments post back into the EBS payment interface against the right operating unit. The manual re-keying is gone and the ledger tracks actual payments.

What you can do

  • Push Oracle E-Business Suite vendor master and GL code combinations into AvidXchange so invoices code to valid payees and accounts.
  • Submit approved AP invoices, with PO reference for matching, from Oracle E-Business Suite into AvidXchange.
  • Pull settled check, ACH, and virtual-card payment detail from AvidXchange and stage it into the EBS AP payment interface.
  • Bridge the EBS session token and operating-unit context with AvidXchange Company and User tokens on every call.
  • Poll on a schedule with low concurrency, duplicate detection, and a full audit trail on every record.

Questions

Which direction does data move between Oracle E-Business Suite and AvidXchange?
Both ways. Vendor master records, GL code combinations, and approved AP invoices move from Oracle E-Business Suite into AvidXchange, and settled payment detail moves from AvidXchange back into EBS. GL accounts are read-only inside AvidXchange, and approval routing stays there, so only the resulting status and payment return to EBS.
How are payments written back into Oracle E-Business Suite?
EBS writes are two-step. ml-connector inserts the settled payment into an open interface table, so a 200 response means the row was staged, not posted. The connector then confirms the concurrent program ran before marking the record complete, and it sets the interface SOURCE column plus a natural key so the same payment is never imported twice.
Do either of these systems support webhooks, or is this polling?
It is polling. Oracle E-Business Suite has no self-service webhook, and AvidXchange has no confirmed public webhook, so ml-connector reads EBS open interface views filtered on last update date and polls the AvidXchange payment endpoint after each batch. The sync runs on a schedule you set, tied to your AP cycle.

Related integrations

Connect Oracle E-Business Suite and AvidXchange

Free to use. Add your credentials, ping your real systems, and see if we fit.

Get started