OLTP Answers versus BI Publisher

(Benefits/Relevance of OLTP Answers)

• Oracle Discoverer to Answers Utility (for rapid dev of addl reports)
• Better empowerment: Users can build their own reports
• (Future) Oracle delivered OLTP reports on the horizon
• Integrated support for real time reports against OLTP (views/tables) as well as Analytic reports against OBIA (Data warehouse)
• Reports will need “pseudo-stars” in RPD (addl. complexity)
• Concerns around “cluttering” of RPD
• Integrated, role-based security with OBIA
• Better flexibility in terms of parameter control etc.
• Supports standard drill-down capabilities
• Better report organization (Dashboard and pages)
• Support for frequency-based scheduler
• Support for business-driven notifications
• Mobile BI experience

(Benefits/Relevance of BI Publisher)

• Simpler process (reports run directly against EBS views)
• Ability to bypass RPD (potential for better performance)
• Support for interactive Excel worksheets & Pivots
• Support for multiple formats (HTML, PDF, RTF, Excel etc.)
• EBS R12 has significant BI Publisher reports (non-OBI)
• Capability to build “pixel perfect” reports (Allows control over the content on each pixel on the report page)
• Parameter control limited to the query run time only
• No drill-down capabilities
• Purely based on a “scheduler” concept
• Role-based content delivery (Bursting)