Leverage the power of BI Publisher in Cloud integrations

By now we are all accustomed to running Applications in the Cloud and it has reached the next phase: extensibility and integrating of the Cloud Applications with other applications in our enterprise architecture. Oracle is investing a lot on this area with PaaS, IaaS, DBaaS, MWaaS, JaaS and everything else that ends with aaS. This will work fine if you are a Sales Cloud customer, where you have the ability to create custom objects, outbound calls, etc.

But what if you're a Cloud ERP or HCM customer? Integration here is currently limited to file based extracts, file based loaders, spreadsheet loaders and web services that have been made available to be consumed externally. In real-time integrations you may be confronted with data needs that are not (yet) available by the web services provided in Cloud Applications, but you also do not the tooling to create custom web services for these needs. Or do you?

Inspired by this blog of FA Developer Relations, I would like to demonstrate how you can create custom real-time data extracts on nearly any data that resides in Fusion, using the PublicReportService

Upgrade to PeopleTools 8.53: What you need to know

It has been a couple of weeks now that PeopleTools 8.53 has been released. Soon customers will upgrade or are even already upgrading to the new PeopleTools release.

To help customers and partner to streamline this process, an Advisor Webcast was held on February 26, 2013: PeopleTools 8.53 Upgrade.

Using RTE enabled fields in BI Publisher with PeopleTools 8.52

In PeopleTools 8.50 adding a Rich Text Editor to Long fields was introduced. With this RTE users are able to actually format text like you would do in for example Microsoft Word. This was a great feature for online entry and presentation in PeopleSoft. Unfortunately this does have a downside. The text that is entered and formatted using RTE gets stored in the database as HTML. This means that when you are using PSQuery to query the data, the data is presented as plain text with the HTML tags and therefor also not usable in any BI Publisher reporting.

With PeopleTools 8.52 a new tempate is introduced that solves this issue and renders the HTML tags in the Long field to the actual formatting the same way as presented in online PeopleSoft.

BI Publisher enhancements in PeopleTools 8.52

Yesterday (January 7th 2012), I attended the online Web Seminar  Why to use BI Publisher? New Features in PeopleTools 8.52 and a few interesting topics were handled that are introduced in PeopleTools 8.52 for BI Publisher

• Data entered in PeopleSoft using a Rich Text Editor for Long fields can now be incorporated in BI Publisher sustaining the formatting


• Ability to transform data, using JDeveloper XSL mapper or any third party tool

Getting BIPublisher Desktop for PeopleSoft to work properly

Although BIPublisher Desktop is currently at level 11.1.1.5, PeopleTools is still shipped and embedded with BIPublisher 10.1.3.4. I stumbled into irritating errors after installing BIPublisher Desktop om my desktop, which used to work fine for me in the past. After installing BIPublisher Desktop on Windows 7 with MS Office 2007, I could nicely see the BIPublisher add in menu in the ribbon, but half the action buttons returned the same error :

The macro cannot be found or has been disabled because of your macro security settings.

Even after enabling all macro, setting trusted locations, this error kept popping up when trying to add an Repeating Group of Chart. Reading tons of posts stating registry hacks, deleting files with exd extensions, this still did not correct my issue.