Analytics Catalog/Oracle Fusion ERP
System
Oracle Fusion ERP report catalog
Financials, HCM, and SCM/Procurement — 228 reports, a data dictionary across 2,007 tables, 1,889 bicc View Objects, per-report and module star schemas, and one enterprise data model.
Models & references
Enterprise model
Conformed-dimension model
One model joining every module — bus matrix + fact constellation.
OTBI
Subject areas (221)
Every OTBI subject area mapped to its tables.
Guide
OTBI vs BIP vs BICC
Which Fusion reporting tool to use, when.
BICC PVOs
Financials View Objects
PVO → table map for BICC extracts.
BICC PVOs
HCM View Objects
PVO → table map for BICC extracts.
BICC PVOs
SCM & Procurement View Objects
PVO → table map for BICC extracts.
Cash Management / 6 reports →
CE
Auto Reconciliation Execution Report
The outcome of the automatic bank-reconciliation run — which imported statement lines matched system…
CE
Cash to General Ledger Reconciliation Report
Compares the general ledger cash account balance to the bank account balance for each account, listi…
CE
Treasury-Loaded Bank Account Information Report
Bank account and statement information loaded into Cash Management from an external treasury system …
CE
Transactions Available for Reconciliation Report
The system-side transactions — payments, receipts, and journals — available to match against importe…
CE
Cash Management Bank Statement Report
Bank account balances and transaction information for specific bank statements — opening and closing…
CE
Cash in Transit Report
For a bank account, the transactions remitted to the bank but not yet cleared as of a date — payment…
Control Reports / 10 reports →
CTRL
AP Financial System Parameters Report
The Payables financial system parameters configured for each business unit — default liability and e…
CTRL
AP System Parameters Report
The Payables system parameters per business unit — default payment terms, tolerance template, date b…
CTRL
Asset Book Controls Report
The configuration of each Assets book — its ledger, account defaults, and calendar and prorate conve…
CTRL
Asset Category Book Report
The depreciation defaults each asset category carries in each book — method, life, bonus rule, and p…
CTRL
GL Period Status Report
The open, closed, or future status of every accounting period by ledger, so the close team can confi…
CTRL
Journal Sources Report
The journal sources configured in the general ledger — where each journal originates (Payables, Rece…
Expenses / 3 reports →
E
Credit Card Issuer Invoice Report
Reconciles the corporate-card issuer's invoice to the card transactions recorded in Expenses — match…
E
Expense Detail Report
Employee expense report detail — each expense line by type, amount, project, and policy status — so …
E
Track Germany Per Diem Report
Tracks per-diem expenses against German statutory rates — meal and accommodation allowances by trip …
Fixed Assets / 24 reports →
FA
Asset Accounting and Location Report
Each asset's accounting and physical location together — cost, accumulated depreciation, and net boo…
FA
Asset Addition and Cost Adjustment Report
Asset additions and cost adjustments for a period — new assets capitalized and changes to existing a…
FA
Asset Audit History Detail Report
The audit trail of changes to asset attributes — cost, category, life, depreciation method, and loca…
FA
Asset Category Exceptions Report
Assets whose category setup is inconsistent with the category-book defaults — wrong or missing depre…
FA
Asset Retirements Report
Assets retired or disposed in a period — proceeds, cost removed, accumulated depreciation backed out…
FA
FA to GL Reconciliation Report
Reconciles the Assets subledger to the general ledger — comparing asset cost, accumulated depreciati…
Fusion Accounting Hub / 5 reports →
FAH
AHCS Create Accounting Errors Report
The errors raised when the Accounting Hub's Create Accounting process tries to account externally-so…
FAH
AHCS Create Accounting Report
The journal entries the Accounting Hub's Create Accounting process produced for externally-sourced t…
FAH
Global SLA Account Analysis
An account-by-account analysis built from Subledger Accounting rather than GL — every accounted line…
FAH
Accounting Hub Journal Entry Line Extract
The journal entry lines the Accounting Hub creates from external source systems — each line's accoun…
FAH
Subledger Period Close Exceptions Report
What is still blocking the close, and in which subledger does each exception sit?…
General Ledger / 42 reports →
GL
Oracle Fusion GL Trial Balance Report
A trial balance for Oracle Fusion — every account's debit and credit balance by ledger as of a date,…
GL
Account Analysis Report
What made this account move this period, and which transactions are behind the balance?…
GL
GL Daily Rates
The daily currency conversion rates loaded in the general ledger — rate by currency pair, conversion…
GL
Account Ledger by Account Greece Report
The Greek statutory account ledger — every posting to each general ledger account over a period, in …
GL
China Account Analysis Detail Report
The detailed account analysis Chinese statutory reporting expects — every voucher line behind each g…
GL
France GL Extract for ETAFI Report
The general-ledger extract that feeds France's ETAFI statutory filing — trial-balance and journal da…
Intercompany / 2 reports →
FUN
Global Intercompany Balances Report
Intercompany receivable and payable balances across every ledger, paired by trading partner, so the …
FUN
Intercompany Invoiced Reconciliation Report
Reconciles intercompany transactions that flowed through Payables and Receivables as invoices — matc…
Lease Accounting / 3 reports →
LA
Lease Activity Detail Report
The accounting activity on each lease in a period — interest accretion, liability reduction, right-o…
LA
Lease Details Report
The register of leases and their terms — commencement and end dates, payment schedule, discount rate…
LA
Lease Disclosure Report
The lease figures financial statements require — future minimum payments by year, the maturity of le…
Payables / 59 reports →
AP
Oracle Fusion AP Aging Report
How much the company owes suppliers, how overdue each balance is, and which suppliers and invoices d…
AP
AP Invoice Detail Report with Tax Details
Invoice-level Payables detail with the tax and withholding breakdown on each line — recoverable and …
AP
AP Disbursements Report
Every payment Payables disbursed in a period — check, EFT, and wire — by supplier, payment method, a…
AP
AP Invoice Detail Report
Invoice-level detail for Payables — header and distribution lines, the account each line hit, holds,…
AP
AP Vendor Financing Batch Creation Inquiry Report
An inquiry into vendor-financing (supply-chain finance) batches — which approved invoices were offer…
AP
Active Employee Details Report
Active employee detail — each employee's organization, supervisor, work email, and default expense a…
Payments / 3 reports →
P
Disbursement Payment File Formats
The disbursement payment file formats configured in Payments — the electronic formats (ISO 20022 pai…
P
Disbursement Positive Pay File Formats
The positive-pay file formats configured for disbursement — the issued-check files sent to each bank…
P
Funds Capture Authorization And Settlement Formats
The funds-capture formats configured for inbound payments — the authorization and settlement file fo…
Projects / 8 reports →
PROJ
Project Listing Details Report
The master list of projects with their key attributes — number, name, type, organization, manager, s…
PROJ
Projects Asset Management Report
Projects that build capital assets — the capital projects and their asset lines, showing constructio…
PROJ
Projects Budgets vs Actuals Report
Project budget against actual cost and commitments by task, with variance and percent spent, so proj…
PROJ
Projects CIP TIP Asset Detail Report
Construction-in-progress detail at the accounting level — every cost line sitting in CIP by project …
PROJ
Projects Exceptions Report
Projects whose setup or plan has a problem — missing budget, no plan version, expired tasks with ope…
PROJ
Projects Global vs Local CER Report
Capital expenditure requests (CER) compared at global and local levels — approved, committed, and sp…
Receivables / 50 reports →
AR
AR Aging Detail Report
Open receivables aged by days past due, line by line — customer, transaction, due date, and bucket —…
AR
AR Applied and Unapplied Receipts Register Report
The receipts register — every receipt in a period showing what was applied to invoices and what rema…
AR
AR Customer Query Report
A query of the customer master — accounts, sites, addresses, and key attributes — the lookup AR and …
AR
AR Open Claim Summary and Detail Report
Customer claims and deductions — short-payments, disputed amounts, and unauthorized deductions — by …
AR
AR Receivable Activity Report
Non-invoice receivables activity — adjustments, write-offs, discounts, and miscellaneous receipts — …
AR
AR Transaction Register Summary and Detail Report
Every receivables transaction created in a period — invoices, credit memos, debit memos, and chargeb…
Transaction Tax / 13 reports →
TAX
Financial Tax Register
The register of tax on transactions — recoverable and non-recoverable tax by tax, rate, and jurisdic…
TAX
Audit Report for France
France's mandatory accounting audit file (FEC — Fichier des Écritures Comptables) — every journal en…
TAX
Unclaimed Property Report (United States)
US unclaimed property (escheatment) — outstanding checks, credit balances, and unapplied receipts th…
TAX
UK Audit File (SAF-T)
The UK tax audit data file — transaction-level sales, purchase, and ledger data assembled for an HMR…
TAX
Tax Register
Tax detail for each transaction including deferred tax accounting, grouped into the tax register and…
TAX
Tax Reconciliation Report
Taxable and tax amounts by tax account for all Receivables transactions and manual or imported outpu…