Posts Tagged ‘11g’


Oracle APEX and BI Publisher

August 9th, 2010 by Robert McMillen • No Comments »

I recently worked on a project that involved an Oracle APEX application.  If you aren’t familiar with APEX, it’s  a database-centric rapid application development product that is included with the Oracle 10g and 11g databases.   Using APEX you can generate web-based applications, interact with database tables/views, leverage PL/SQL stored procedures and even integrate it with Oracle BI Publisher.  BI Publisher is an easy-to-use report generation product.

One of our requirements was to generate reports from the application in a PDF format.  I looked at several options and decided for the moment that Oracle BI Publisher was the fastest and simplest solution.  Fortunately the client was happy with that as well.

What I found out was that generating a report from APEX and having it printed as a PDF via BI Publisher is a very elegant solution.  Beyond installing BI Publisher on a server, the following steps were what I need to do.  BTW, we installed BI Publisher in both the windows and Linux environments with no issues.

We had an existing application screen and wanted to generate the PDF using the same underlying SQL queries.  First I logged into the APEX application, went to SHARED COMPONENTS and defined multiple SQL select statements using the REPORT QUERIES option.  I was able to reference some existing session variables to customize the SELECT statements.  In APEX I was able to define a REPORT LAYOUT template under the SHARED COMPONENTS.  Then I downloaded the BI Publisher plug-in for Microsoft Word 2007 and created a report template.  There’s more detail in that process than I can cover here, but it didn’t take long for me to learn how to create more and more complex templates.

I was then able to upload the template to APEX (and download it later for editing).  Since the templates are MS Word documents, it’s pretty straight-forward.

Back in APEX I modified the logic on one of the application web pages to add a button.  This button was linked to a BRANCH statement which called BI Publisher and generated the PDF Report.  Within a few seconds my browser had a download of the PDF file which I could open and browse!

Within several weeks we had created about a dozen reports, each with 5 or 6 SQL queries.  Some executed directly out APEX and others were scheduled to run directly from BI Publisher on an automated schedule.  If you want to learn more about the link between APEX and BI Publisher, here are some examples.  Happy Report Writing!

Defining a PDF Report in APEX

No Comments »

 

Protected: Coming Soon: Leveraging BPM 11g Capabilities – Argument Mapping

February 11th, 2010 by Mark Peterson • Comments Off

This post is password protected. To view it please enter your password below:


Comments Off

 

Oracle spotlights BPM in Fusion Middleware Story

October 12th, 2009 by Mark Peterson • No Comments »

After hearing the Fusion Middleware story many times now, I am so relieved and happy to see Business Process Management (BPM) in the spot light once again.  During the Oracle Open World 2009 General Session “Oracle Fusion Middleware 11g Foundation for Innovation” we heard about SOA, the Enterprise 2.0 Portal and Tuxedo; but what is that? We were given a demo of the new Oracle BPM 11g application development environment. We got to see swim-lanes, process models, simulations and dash-boards. They showed how you can obtain process model metrics and key performance indicators for your process.  They made significant improvements over the way BPM integrates with applications and systems.

I feel this completes the Oracle’s Fusion Middleware Story. BPM spans the entire Fusion product suite and needs to be in the spot-light. No other application takes a holistic view of the enterprise and provides a coherent platform to integrate business application the way the business needs them.  We’ve heard many times that it’s not about IT anymore. That is certainly true. It should be about Business Processes and BPM solutions needs be part of the strategy.

No Comments »

 

New Release of the Database 11g R2 Now Available

September 10th, 2009 by Robert McMillen • No Comments »

Oracle has just announced availability of a new release of their 11g Database.  This is the second release for 11g and since many customers like to wait for a second release of new products before considering them production-worthy this version is one that many customers will be considering.

Oracle is offering local events around the country where customers can find out more about this new release.  Just follow the links below to register for an event in your area of the country.  Also, if you are going to Open World there will be a number of sessions there on the new release.

Oracle is advertising that this new release will

  • Reduce server costs by a factor of 5
  • Reduce storage requirements by a factor of 12
  • Improve mission critical systems performance by a factor of 10
  • Increase DBA productivity by a factor of 2
  • Eliminate idle redundancy in the data center, and
  • Simplify their overall IT software portfolio.

More overall  information can be found HERE.  The Oracle Technology Network (OTN) information can be found HERE and allows you to download an evaluation version.

The Oracle database continues to be the leading database worldwide.  Gartner’s 2008 Worldwide RDBMS Market Share Report shows Oracle with a 48.9 percent share, and IDC’s 2008 Worldwide Data Warehouse Platform Software 2008 Vendor Shares reports a 40 percent share.

No Comments »

 

What Oracle is Doing Right

August 3rd, 2009 by Robert McMillen • No Comments »

For a change of pace I thought it would be good to  mention a few of the things I think that Oracle is doing right.   Over the last several years I continue to be impressed with what I see coming out of Oracle related to their product directions and new products.  Here’s my take on the things I see Oracle doing right.

The first one I’ll note is that Oracle is doing a great job at maintaining a Leadership Role in software innovation.  It’s obvious if you look at various evaluations such as the “Magic Quadrant” by Gartner that Oracle’s products are consistently in the top right quadrant where market leaders are found.  Here are a few Oracle products that I’ve had the opportunity to work with.

  • E-Business Suite R12 – R12 is more evolutionary than revolutionary but it significantly improves on what was a solid release in 11i by expanding the international capabilities of this massive applications suite.  With over 224 separate modules, R12 is mind-boggling in it’s scope of capabilities.  Oracle gets some dings for the bugs that were found in the first year  but they’ve quickly addressed the core issues in the releases leading up to release 12.1.  While there is an improved user interface the real changes are beneath the surface and which improve the productivity of everyday users.
  • 11g Database – there are many people who are better qualified to speak on this product than I but as one who has been working with the Oracle database since the last legs of version 6 I’m amazed that  Oracle continues to add useful and valuable capabilities to this workhorse of a database system.  In the areas of performance, operating systems supported, scalability and reliability the Oracle database keeps most of the world’s business working smoothly.  Yes the management interfaces are not as slick as they could be but the newer versions of Oracle Enterprise Manager tend to overwhelm me with information.  The power of PL/SQL remains a constant in the middle of all of the changes we have seen over the years.  Each new release allows more parameters to be changed on the fly rather than requiring downtime.  Recently introduced capabilities that I think will change the future of data management include Real Applications Testing, Active Data Guard, Database Vault and Total Recall.  There’s much more and I’ll probably get dinged in my comments for leaving it out but enough said.
  • Fusion Middleware 11g – Just released and while most of us are still trying to digest it all let me summarize it as a significant statement of Oracle’s capabilities to innovate dozens of products and continually integrate them in ways that architects, developers and management can better deliver business solutions that evolve more and more quickly.  The introduction of better technologies from the BEA acquisition has positioned Oracle to be the dominant player in this market.
  • JDeveloper 11g – This IDE has to compete with dozens of other great Java IDE’s like Eclipse and Aptana but still is a stand out.  This product offers all the bells and whistles including the ability to interact with all areas of the database and middleware environments that Oracle offers.  Additionally the capabilities of the Application Development Framework simplify the development of very robust user interfaces incorporating the best Web 2.0 goodies.  Using JDeveloper I can do Use Case design, write code, test, develop a database design and still not delve all of its capabilities.
  • Fusion Applications – Though not yet  released this coming Applications Suite will introduce an innovative User Interface that is a mash-up of the best of Web 2.0 and what Oracle has learned from it’s product acquisitions (such as PeopleSoft).  Built on Oracle Fusion Middleware capabilities this application will bring Service Oriented Architecture and more industry-standards to the underlying technology stack.    The focus on improving user productivity already seen in the UI will be much appreciated by those who do the real daily work of running the details of a business.
  • Miscellaneous - Kudos to Oracle for supporting the Open Source community by releasing versions of products that they have developed (see here).

Ok, it’s time to take a rest from this area of adulation and move to the second item I think Oracle has done well.  I’ll cover that in the next post.

No Comments »

 

What Seems Hot at OpenWorld 2008

September 22nd, 2008 by Robert McMillen • No Comments »

These are the types of presentations that seem hot (in descending order):

  1. Service Orient Architecture Integration/Fusion Middleware
  2. E-Business Suite, Release 12
  3. Functional Seminars (focusing on various E-Business Suite modules)
  4. Hyperion
  5. 11g Database
  6. Enterprise Performance Management

This may change as the week progresses and Oracle continues to make new announcements.  For full-disclosure there are also sessions for BEA, PeopleSoft, JD Edwards and Siebel so it’s not just EBS….

No Comments »