Vendor master deduplication
The last profiling run flagged 936 duplicate vendor groups in Oracle EBS. Watch the agent resolve the ones that move the money: pull trailing-12-month spend, classify by tax ID and bank account and legal entity, auto-merge the safe ones, queue the conflict cases for AP review, and reconcile spend totals to the dollar before signing off.
What this does
The last profiling run flagged 936 duplicate vendor groups in Oracle EBS. The agent resolves the ones that move the money.
It queries AP for trailing-12-month spend per group, filters to the 140 over $25K, and classifies each by tax ID, bank account, and legal entity. Conflict checks: payment terms, open POs, open invoices.
It auto-merges 62 safe groups in Oracle Cloud, retires 131 records, reassigns 23 open POs with 0 orphans, queues 53 conflict cases for AP review, and clears 25 confirmed non-duplicates.
Reconciliation gate: vendor spend matches before and after to the dollar. Nothing ships until the gate passes.
How it works
Two connectors run in sequence.
- Oracle EBS supplies the staging duplicate groups, the AP invoice history, and the classification signals (tax ID, bank account, legal entity).
- Oracle Cloud ERP executes the merges, retires records, reassigns open POs, writes the AP review file, and runs the reconciliation gate.
Same shape an AP-operations engineer would use: filter by impact, classify by safety, merge the safe ones, escalate the rest, gate on reconciliation.
Outcomes you can verify
62 groups auto-merged: 131 records retired, 23 POs reassigned, 0 orphaned.
53 conflict cases exported to vendor-dedup-review.csv for AP operations. 25 groups cleared as non-duplicates. 796 below threshold deferred to the next run.
Reconciliation: vendor spend matches before and after at $184.3M. Staging trims from 12,418 to 12,287 active records.