# Automated Accounts Payable Reconciliation in Oracle and Sharepoint

> Watch Kognitos match an emailed invoice against Oracle Fusion, handle a Qty / Quantity column mismatch, and write the reconciled record into SharePoint with an audit email.

**Page**: https://www.kognitos.com/videos/automated-accounts-payable-reconciliation-in-oracle-and-sharepoint/
**Watch on YouTube**: https://www.youtube.com/watch?v=sntE1a_5tcM
**Length**: 3m 54s

## What's in this video

A 4-minute walkthrough of an end-to-end accounts payable reconciliation: emailed invoice → Oracle Fusion lookup → SharePoint write → controller notification. The whole process is built and audited in plain English.

## What Kognitos does, step by step

- **Connect to Oracle Fusion**: Kognitos uses API connections to the ERP, not screen scraping — important for stability at scale.
- **Extract from the invoice**: the emailed invoice (front and rear brakes labor, with quantity and unit price) is parsed into structured fields.
- **Look up in Oracle**: Kognitos finds the same invoice number in Oracle Fusion and extracts the matching record.
- **Build a merge table**: a joined view shows the invoice data and the Oracle data side by side.
- **Handle column-name drift**: the invoice uses *Qty* while Oracle uses *Quantity*. Kognitos recognises that the fields mean the same thing — no mapping table required.
- **Write to SharePoint**: when the values reconcile, Kognitos creates the record file in SharePoint as proof the match occurred.
- **Notify the controller**: an email goes out with the merged CSV attached so finance has a side-by-side audit packet.

## English-language audit trail

As the automation runs, every step is logged in English — including the “facts” (blue-highlighted values) Kognitos extracted from documents and from the ERP. That makes the run readable by AP managers, controllers, and auditors without involving a developer.

## FAQs

**Q: Which systems does this AP reconciliation connect to?**

Oracle Fusion (the ERP), Microsoft SharePoint (the destination for the reconciled file), and the team's email (both the inbound invoice trigger and the outbound controller notification).


**Q: How does Kognitos handle the Qty vs Quantity column-name difference?**

Kognitos recognises that the invoice's Qty column and Oracle Fusion's Quantity column refer to the same field. No mapping table is needed — the platform infers the equivalence and continues with the reconciliation.


**Q: Is this RPA screen-scraping Oracle Fusion?**

No. Kognitos uses API-based automation. It connects to Oracle Fusion as an API consumer, which is more reliable than UI screen-scraping and explains why the same approach scales to other systems.


**Q: What audit trail does the controller get?**

An email with the merged CSV attached (invoice values on the left, Oracle values on the right) plus a copy of the reconciled record stored in SharePoint. The Kognitos run log itself is also human-readable English with all extracted facts.