Tables
The connector models the data in Oracle Fusion Cloud Financials as a list of tables in a relational database that can be queried using standard SQL statements.
CData Power BI Connector for Oracle Fusion Cloud Financials Tables
| Name | Description |
| ExpenseReports | Contains header-level details for expense reports, such as total cost, status, and submission date for auditing and payment tracking. |
| Expenses | Acts as the master resource for all incurred expenses by employees, centralizing data for reporting and approvals. |
| Invoices | Manages key supplier invoice data, including header, lines, distributions, installments, and descriptive flexfields for payables processing. |
| InvoicesinvoiceDff | Supports organization-specific data fields on invoices, leveraging descriptive flexfields for custom reporting or validations. |
| InvoicesinvoiceInstallments | Tracks multiple payment installments tied to a single invoice, detailing amounts and due dates for staged payables. |
| InvoicesinvoiceLines | Captures goods, services, freight, and miscellaneous charges at the invoice line level, forming the basis for accounting entries. |
| InvoicesinvoiceLinesinvoiceDistributions | Creates distribution records per invoice line, detailing account numbers, distribution dates, and expense allocations. |
| ReceivablesCreditMemos | Manages credit memo records in Receivables, including creation, retrieval, and referencing for financial adjustments. |
| ReceivablesInvoices | Controls the creation, retrieval, and management of receivables invoices, streamlining billing and revenue tracking. |
| StandardReceipts | Tracks standard incoming payments (for example, checks, wire transfers), mapping them to customer accounts for settlement. |
| TaxRegistrations | Controls creation and updates of tax registrations, linking registered entities to corresponding tax codes and authorities. |