Automated Accounts Payable Reconciliation in Oracle and Sharepoint

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.