ERP & APOracle Fusion Cloud ERP and Trace Global
Connect Oracle Fusion Cloud Payables to reconcile utility invoices and payments and import audited invoices through FBDI.
- Vendor
- Oracle
- Method
- Payables REST APIs (invoices and payments resources), BI Publisher extracts and FBDI invoice import
- Direction
- Bidirectional
- Typical setup
- 2 to 3 weeks
Large retailers and REITs on Oracle Fusion Cloud ERP usually process utility bills through Payables with a dedicated invoice source. Trace Global reads those invoices and payments through the Payables REST APIs so every audited statement is matched to the posted transaction.
For history loads and high volumes, a scheduled BI Publisher report gives us a full extract without paging through the API. For outbound invoices, we generate files in the Payables Standard Invoice Import format for File-Based Data Import (FBDI), or create invoices through REST if you prefer.
Access runs through an integration user with a custom role limited to the Payables objects below.
How the data feeds the audit
- Match statements to invoices to find duplicates entered under different invoice numbers.
- Quantify late fees by comparing payment dates with utility due dates.
- Find invoices posted to cost centers for sites that are closed or sold.
- Confirm that refunds and credit memos from utilities were applied.
Setup
- 1Create an integration user and a custom role with Payables read access.
- 2Schedule the BI Publisher extract for utility invoice sources.
- 3Share the REST endpoint and credentials through the credential vault.
- 4Reconcile 12 months of invoices to captured bills.
- 5Turn on FBDI or REST invoice creation if you want outbound posting.
Data exchanged
| Object | Detail |
|---|---|
| Invoices | Invoice number, supplier, supplier site, business unit, invoice date, amount and validation status. |
| Invoice distributions | Distribution combinations (company, cost center, account, location) per line. |
| Payments | Payment numbers, dates and amounts applied to each invoice. |
| Suppliers and sites | Utility supplier records and remit-to sites matched to utility accounts. |
| Audited invoices (outbound) | FBDI import files or REST-created invoices with the bill attached. |
Oracle Fusion Cloud ERP questions
Yes, through the Payables Open Interface and database extracts. The REST APIs apply to Fusion Cloud only.
They go through your normal Payables validation and approval. We do not bypass holds.
Yes. The role's data access can be limited to the business units in scope.
Related connectors
Find out what your utilities owe you.
Connect bills for up to 50 meters. Get the findings report in about three weeks. Pay nothing unless money comes back.
- from bill access to first findings report
- 21 daysfrom bill access to first findings report
- of filed claims accepted by the utility in full or in part
- 94%of filed claims accepted by the utility in full or in part