Published Paper Details:

This review explores the dual capabilities of Oracle Cloud's BI Publisher and Oracle Transactional Business Intelligence (OTBI), evaluating their roles in enterprise reporting and analytics. As organizations migrate to cloud-native ecosystems, real-time analytics and formatted reporting have become integral to data-driven decision-making. OTBI empowers end-users with self-service analytics while BI Publisher supports pixel-perfect document generation. Through comparative performance studies, user satisfaction surveys, and architectural modeling, this paper reveals the strengths, limitations, and applications of each tool. It further proposes a theoretical framework and experimental insights to assist IT leaders in choosing the appropriate tool based on complexity, data latency needs, and reporting frequency. Future research opportunities include AI-enhanced analytics, cross-platform integration, and adaptive user experience design to address existing gaps in scalability, visualization, and interoperability.