Wednesday 29 February 2012

Oracle Fusion Applications 101: BI & Reporting

Oracle Fusion Applications provides an extensive range of BI Reporting tools and capabilities all tightly integrated with the FA user experience (UX).

The Business Intelligence and Reporting infrastructure is delivered by Oracle Business Intelligence Enterprise Edition, OBIEE provides analysis tools, interactive dashboards, alerts and an enterprise reporting engine that lies at the heart of the BI and Reporting capability for FA. A number of BI products are integrated with OBIEE to deliver the FA BI and Reporting expierience:

Oracle Business Intelligence Publisher (BIP) - The latest incarnation of the old XML Publisher, a pixel perfect reporting tool, providing a complete enterprise solution for authoring, managing, and delivering reports from multiple data sources (SQL, ADF-BC View Objects, XML) in multiple formats (PDF, Excel, HTML) through multiple channels (E-Mail, Print, File).

Oracle Business Intelligence Applications (OBIA) - A prebuild data warehouse for FA transactional data, provides the warehouse database schema and the logic that extracts data from the Oracle Fusion Applications transactional database and loads it to the warehouse; OBIEE reporting tools like Answers and Dashboards are used to query data.

Oracle Transactional Business Intelligence (OTBI) - Allot of confusion and hype around OTBI, will dedicate my next post to it, follow me on twitter @FusionApps101.

ESSBASE"Extended Spread Sheet dataBASE", selectively used to enhance the FA reporting capability, used by Fusion Financials in the Fusion Accounting Hub application to delivery real-time analytic reporting on General Ledger Balances.

Like most things with Fusion Applications, the BI Reporting strategy and capabilities are extensive and initially somewhat bewildering. It takes time to wrap your head around Oracle's master plan for OLTP BI and Reporting, but WOW what a brave new world!

Sunday 19 February 2012

Oracle Fusion Applications 101: Enterprise Scheduling Service

I suspect these posts will continually try to relate functionality in Fusion Applications (FA) with my background in Oracle e-Business Suite (EBS), so apologies if your from the JD Edwards, PeopleSoft or Siebel crowd.

SAP? Well no apologies or sympathy, we all have our problems.

The Enterprise Scheduling Service (ESS) provides the EBS Concurrent Manager equivalent service in FA but with an extended list of features and functionality. The Enterprise Scheduler is a J2EE application that provides schedule based callbacks to other applications to run their jobs, it does not execute the jobs itself.

Here is some interesting points to note:
  • Completely Metadata driven: the metadata consists of job definitions, including the executable class, parameters and schedules. All Metadata is created using Oracle JDeveloper, limited functionality via FA ESS Job Definition UI to register a Job.
  • Job Definition or Job = Concurrent Program in EBS.
  • Job Set = Request Set in EBS, sequential or parallel set of Job Steps, where a Job Step can be a single Job or another Job Set.
  • Different job types, including JAVA, SQL, PL/SQL, SQL*LOADER, C, HOST and BIPublisher.
  • Includes features like Incompatibility, Schedules and Workshifts.
  • Monitoring of jobs through ESS Monitor UI and/or Oracle Fusion Applications Control (Enterprise Manager)
Want to know more, see the Oracle® Fusion Applications Developer's Guide for Oracle Enterprise Scheduler for more detail.

#OracleFusionApplicationLesson 2 for Oracle EBS Developers: Your going to be defining concurrent programs through JDeveloper.