Oracle Transactional Business Intelligence (OTBI) is the tool designed specifically for this requirement. OTBI provides real-time, self-service reporting directly against the transactional tables in the Oracle Fusion Cloud Applications database. This architecture allows business users to create and run analyses with up-to-the-minute data without the latency associated with a traditional data warehouse that requires periodic data loads and transformations. It is built on a semantic layer that simplifies the underlying complex data structures for end-users.

B. An Account Group is a tool used within Financial Reporting to group and format rows of related accounts; it is not a reporting tool itself.

C. Smart View is an Excel add-in primarily used for analyzing, importing, and updating data from Essbase cubes or General Ledger balances, not for real-time reporting on transactional tables.

D. Financial Reporting Studio is used for creating highly formatted, book-quality financial statements (e.g., balance sheets, income statements) that typically report on pre-aggregated GL balances from Essbase.

1. Oracle® Fusion Cloud Financials, Creating and Administering Analytics and Reports for Financials, Release 24A, F81488-03, Chapter 2: "Oracle Transactional Business Intelligence". The documentation states, "Oracle Transactional Business Intelligence is a real time, self-service reporting solution... that provides you with easy access to transactional data."