Hierarchy Visualization in OTBI using Google Organization Charts

From time to time I am asked by my customers and prospects who are wondered if there is any way with in Oracle HCM Cloud to represent hierarchical organizational structures in graphical views. I knew that Oracle BIEE can use Google Charts APIs to render Organization Charts and I tried to sort out the details to get the most of that technique. I also was going to figure out how to place some formatting and interactive features. let’s see what I managed to get.

Google Charts library can be utilized within Fusion HCM OTBI for visual representation of Management Hierarchies as well as Department – Position – Employee relationships.

So how does the API work? That is a JavaScript library so the basic knowledge of JavaScript will be helpful. Basically we include the API on our narrative view and then make calls to the various methods provided. The developer page has a simple example that we can use as our starting point. Please take a quick look over there before continuing reading. https://developers.google.com/chart/interactive/docs/gallery/orgchart

Let me briefly introduce the steps how to build Organization Charts in OTBI Analysis.

Please read the rest of the article at the erpwebtutor.com portal.

Advertisements

Taleo Business Edition Fusion HCM New Hire Integration

Last month Oracle released the first version of TBE – Fusion HCM integration capability. It was a long waited feature I waited from Oracle for a couple of years. Finally they started moving in this direction.
It is available starting from Taleo Business Edition Release 17A1.
I suppose the main reason is a growing number of customers who prefer to order Fusion HCM bundle for mid-size companies and also want to get Taleo Business Edition for talent acquisition processes. Customers realized that there is no OOTB integration between TBE and Fusion products like Taleo EE has and were forced to develop custom integration scenarios. But as I have been convinced many times Oracle makes huge investments only if they sure for one hundred percent in quick return. It seems this time is coming.

Continue reading