Analytics Catalog/Oracle Fusion ERP/Transaction Tax
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion ERP · TAX

Transaction Tax reports

Every Transaction Tax report — logic, source tables, parameterized SQL, the data dictionary, a star-schema data model, and extraction patterns. 13 reports.

Transaction Tax data model

The module's conformed star — the fact every Transaction Tax report rolls up to, surrounded by the dimensions shared across the module. See the full Transaction Tax data model → — all star schemas, the model dictionary, use cases, and every bicc View Object this module exposes.

AP_INVOICES_ALLconformedRA_CUSTOMER_TRX_ALLconformedZX_RATES_BconformedGL_CODE_COMBINATIONSconformedZX_LINESfact · Transaction Tax grainAmount · Count
●— fact → dimension join

Reports

TAX
Financial Tax Register
The register of tax on transactions — recoverable and non-recoverable tax by tax, rate, and jurisdiction, tied…
TAX
Audit Report for France
France's mandatory accounting audit file (FEC — Fichier des Écritures Comptables) — every journal entry for th…
TAX
Unclaimed Property Report (United States)
US unclaimed property (escheatment) — outstanding checks, credit balances, and unapplied receipts that have go…
TAX
UK Audit File (SAF-T)
The UK tax audit data file — transaction-level sales, purchase, and ledger data assembled for an HMRC inspecti…
TAX
Tax Register
Tax detail for each transaction including deferred tax accounting, grouped into the tax register and nonrecove…
TAX
Tax Reconciliation Report
Taxable and tax amounts by tax account for all Receivables transactions and manual or imported output tax for …
TAX
Tax Reconciliation by Taxable Account Report
Transactions ordered by tax rate code and taxable account, with totals per account within each rate code, to r…
TAX
Tax Audit Trail Report
A full audit trail of tax on transactions — taxable and tax amount, rate, recovery, and the accounts — for tax…
TAX
Tax Box Allocation Report
Transactions allocated to the tax boxes of a tax return, mapping each taxable and tax amount to the box it rep…
TAX
Tax Allocations Listing Report
Lists how transactions were allocated to tax boxes for a period — the supporting detail behind the tax box ret…
TAX
Sales Tax Report
US sales tax by jurisdiction and rate for Receivables transactions — the basis for state and local sales-tax r…
TAX
Use Tax Liability Report
Self-assessed use tax on Payables transactions where the supplier didn't charge tax — the basis for the use-ta…
TAX
Withholding Tax Report
Tax withheld from supplier payments by withholding type and supplier — the basis for withholding remittance an…