Whitepaper: An Idea - Solution Framework for Operational BI in Oracle Applications

Problem Statement:

Oracle Applications provides many features for end users to enter and maintain information through Oracle Forms, OAF & ADF pages, Oracle Reports. Sometimes these pages show less or no real-time information related to the entity that is being entered or maintained in Oracle Applications.

Solution Statement:

The following methodology would provide a path to collect and display operational, summarized additional information while entering or maintaining data entities in Oracle Applications.

Considerations:

-          Performance considerations need to be taken care in implementing this concept

-          Proper infrastructure should be in place to have quick access to operational information

-          Separate schedules need to be built-on, to retrieve and show relevant data

-          Heavy customization / enhancement on already existing forms & OAF, ADF pages

-          Separate repository for easy maintenance and performance consideration

Tools & Architecture:

Platform / Tool	Feature to use for real time data display
Forms 9i & 10g	Extending forms with Java for real-time information
OAF Pages	Partial Page Rendering
ADF	ADF Faces components – partial page render
HTML pages	JavaScript & AJAX (Which are not supported by Oracle)

Challenges

-          System Architecture (Design, ODS)

-          Query Performance

-          Infrastructure Cost

-          Data

o   Data acquisition

o   Data Storage

o   Data Delivery