This OTBI report is built to provide an interactive analysis of supplier invoices in Oracle Payables using both table and graph views. It supports comparative visualization and drill-down insights for key invoice-related metrics such as invoice amount, tax, paid, and outstanding balances. The View Selector feature in this report allows switching between tabular and graphical displays.
📊 Subject Area
🔹 Payables Invoices – Transactions Real Time
📋 Columns Included
Business Unit Name
🔹 Supplier
🔹 Invoice Number
🔹 Invoice Date
🔹 Invoice Amount
🔹 Invoice Amount Paid
🔹 Invoice Currency
🔹 Payment Status Name
🧠 Calculated Fields
🔹 Tax (0.08%): Custom formula to represent an assumed tax on invoice.
🔹 Outstanding Amount: Final amount remaining after tax and payment, calculated via a complex expression.
🎨 Graph View & Conditional Formatting
🔹 Red for values > certain threshold (e.g., unpaid or large outstanding)
🔹 Green for fully paid
🔹 Amber for partially paid
🔀 Views Used
View Selector Enabled:
🔹 Tabular View: Full data for analysis and export
🔹 Graph View: Visualization of total, tax, paid and outstanding amounts
🔐 Access & Security
✔️ Accounts Payable Analysts
✔️ Finance Managers
✔️ Procurement Operations Team
