HCM Cloud – Bulk Integration Automation Using SOA Cloud Service by Jack Desai

August 23, 2016 Leave a comment

clip_image002

 

Introduction

Oracle Human Capital Management (HCM) Cloud provides a comprehensive set of tools, templates, and pre-packaged integration to cover various scenarios using modern and efficient technologies. One of the patterns is the batch integration to load and extract data to and from the HCM cloud. HCM provides the following bulk integration interfaces and tools:

HCM Data Loader (HDL)

HDL is a powerful tool for bulk-loading data from any source to Oracle Fusion HCM. It supports important business objects belonging to key Oracle Fusion HCM products, including Oracle Fusion Global Human Resources, Compensation, Absence Management, Performance Management, Profile Management, Global Payroll, Talent and Workforce Management. For detailed information on HDL, please refer to this.

HCM Extracts

HCM Extract is an outbound integration tool that lets you select HCM data elements, extracting them from the HCM database and archiving these data elements as XML. This archived raw XML data can be converted into a desired format and delivered to supported channels recipients.

Oracle Fusion HCM provides the above tools with comprehensive user interfaces for initiating data uploads, monitoring upload progress, and reviewing errors, with real-time information provided for both the import and load stages of upload processing. Fusion HCM provides tools, but it requires additional orchestration such as generating FBL or HDL file, uploading these files to WebCenter Content and initiating FBL or HDL web services. This post describes how to design and automate these steps leveraging Oracle Service Oriented Architecture (SOA) Cloud Service deployed on Oracle’s cloud Platform As a Service (PaaS) infrastructure.  For more information on SOA Cloud Service, please refer to this.

Oracle SOA is the industry’s most complete and unified application integration and SOA solution. It transforms complex application integration into agile and re-usable service-based components to speed time to market, respond faster to business requirements, and lower costs.. SOA facilitates the development of enterprise applications as modular business web services that can be easily integrated and reused, creating a truly flexible, adaptable IT infrastructure. For more information on getting started with Oracle SOA, please refer this. For developing SOA applications using SOA Suite, please refer to this.

These bulk integration interfaces and patterns are not applicable to Oracle Taleo.

Main Article

HCM Inbound Flow (HDL)

Oracle WebCenter Content (WCC) acts as the staging repository for files to be loaded and processed by HDL. WCC is part of the Fusion HCM infrastructure.

The loading process for FBL and HDL consists of the following steps:

  • Upload the data file to WCC/UCM using WCC GenericSoapPort web service
  • Invoke the “LoaderIntegrationService” or the “HCMDataLoader” to initiate the loading process.

However, the above steps assume the existence of an HDL file and do not provide a mechanism to generate an HDL file of the respective objects. In this post we will use the sample use case where we get the data file from customer, using it to transform the data and generate an HDL file, and then initiate the loading process.

The following diagram illustrates the typical orchestration of the end-to-end HDL process using SOA cloud service: Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture Tagged with , , , , , ,

ServiceCloud Rightnow Integration, XSLT Transformations! By Fabio Persico

July 20, 2016 Leave a comment

 

clip_image002I’ve just roll out to a live environment, a SOA Integration project with Oracle Service Cloud Rightnow.

The customer needed to migrate from a in-house CRM to Oracle Service Cloud and with my company Infomentum we have helped them in taking this big step. Since that I have made lots of experience with OSC WebServices.

Here I just want to share the complex XSLT Transformation which we have implemented to communicate with the OSC WebServices, hopefully these can speed up any other SC integration projects.

There are 6 transformation in the ZIP package (we have implemented more):

XSLT Name

SC Object

Out of the box Object?

Operation Type

xsltContact2Update

CONTACT

Yes

UPDATE

xsltOrganisationToUpdate

ORGANIZATION

Yes

UPDATE

xsltProgrammeToUpdate

CO.PROGRAMME

No

UPDATE

xsltProgrammeTypeToUpdate

CO.PROGRAMMETYPE

No

UPDATE

xsltCourseToUpdate2

CO.COURSE

No

UPDATE

xsltSessionToUpdate

CO.SESSION

No

UPDATE

In the XSLTs you’ll find all the details about the TARGET columns (Oracle Service Cloud ones). Here are some important concepts I want to highlight:

  • SC Columns in the XSLT are sometimes out of the box column, in some other cases they are custom ones. In the XSLT the latter will be identified with the tag GenericFields. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture, Cloud, SOA Tagged with , , , , , , , , , ,

HCM Cloud – Bulk Integration Automation Using SOA Cloud Service by Jack Desai

July 19, 2016 Leave a comment

 

clip_image002Introduction

Oracle Human Capital Management (HCM) Cloud provides a comprehensive set of tools, templates, and pre-packaged integration to cover various scenarios using modern and efficient technologies. One of the patterns is the batch integration to load and extract data to and from the HCM cloud. HCM provides the following bulk integration interfaces and tools:

HCM Data Loader (HDL)

HDL is a powerful tool for bulk-loading data from any source to Oracle Fusion HCM. It supports important business objects belonging to key Oracle Fusion HCM products, including Oracle Fusion Global Human Resources, Compensation, Absence Management, Performance Management, Profile Management, Global Payroll, Talent and Workforce Management. For detailed information on HDL, please refer to this.

HCM Extracts

HCM Extract is an outbound integration tool that lets you select HCM data elements, extracting them from the HCM database and archiving these data elements as XML. This archived raw XML data can be converted into a desired format and delivered to supported channels recipients.

Oracle Fusion HCM provides the above tools with comprehensive user interfaces for initiating data uploads, monitoring upload progress, and reviewing errors, with real-time information provided for both the import and load stages of upload processing. Fusion HCM provides tools, but it requires additional orchestration such as generating FBL or HDL file, uploading these files to WebCenter Content and initiating FBL or HDL web services. This post describes how to design and automate these steps leveraging Oracle Service Oriented Architecture (SOA) Cloud Service deployed on Oracle’s cloud Platform As a Service (PaaS) infrastructure.  For more information on SOA Cloud Service, please refer to this.

Oracle SOA is the industry’s most complete and unified application integration and SOA solution. It transforms complex application integration into agile and re-usable service-based components to speed time to market, respond faster to business requirements, and lower costs.. SOA facilitates the development of enterprise applications as modular business web services that can be easily integrated and reused, creating a truly flexible, adaptable IT infrastructure. For more information on getting started with Oracle SOA, please refer this. For developing SOA applications using SOA Suite, please refer to this.

These bulk integration interfaces and patterns are not applicable to Oracle Taleo.

Main Article

HCM Inbound Flow (HDL)

Oracle WebCenter Content (WCC) acts as the staging repository for files to be loaded and processed by HDL. WCC is part of the Fusion HCM infrastructure.

The loading process for FBL and HDL consists of the following steps:

  • Upload the data file to WCC/UCM using WCC GenericSoapPort web service
  • Invoke the “LoaderIntegrationService” or the “HCMDataLoader” to initiate the loading process.

However, the above steps assume the existence of an HDL file and do not provide a mechanism to generate an HDL file of the respective objects. In this post we will use the sample use case where we get the data file from customer, using it to transform the data and generate an HDL file, and then initiate the loading process.

The following diagram illustrates the typical orchestration of the end-to-end HDL process using SOA cloud service: Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture, Cloud, SOA Tagged with , , , , , , , , ,

Maximize the Value of Your CX Investments with Oracle Cloud Platform

July 17, 2016 Leave a comment

 

clip_image001With Oracle CX Cloud, companies not only get the most comprehensive CX offering, but also an innovative and powerful cloud platform to extend, analyze and integrate these applications with the rest of the enterprise resources, as well as to optimize them for every user.  

This session outlines the Cloud Platform (PaaS & IaaS) solutions that Oracle provides to streamline cloud development and empowers you to deliver enterprise-grade solutions rapidly and cost effectively. Join this event if you are interested in the most advanced way to extend, analyze and integrate the Oracle CX solutions. In subsequent webinars, we will drive you through further Integration Solutions’ details.

Agenda:

§ Oracle Cloud Platform Overview

§ Practical use case to extend, analyze and integrate Oracle CX Cloud

§ CX extension & integration demo

§ Partner resources

Schedule:

December 17th 2015 10:00 am CET

For details please visit our registration page here!

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture, Cloud, SOA Tagged with , , , , , , , , , ,

Visualizations are far more than a pretty face on the cloud

June 14, 2016 Leave a comment

clip_image001

Visualizations are probably the most effective way to convey information, insights and prompts for action to humans. We are not terribly good at quickly and correctly interpreting textual information that require sequential processing. Our brains however are very well equipped to rapidly interpret information presented in a well defined visualization. The expression ‘one picture says more than a thousand words’ is one that speaks volumes (and a picture capturing that expression would of course tell us even more…).

Visualizations were omnipresent at last week’s Oracle OpenWorld 2015 conference. From keynote sessions by Larry Ellison and Thomas Kurian to the demo grounds where SaaS applications as well as development tools, PaaS services and other products were demonstrated, visualizations were everywhere. In part because they look nice and have an immediate appeal. But far more than just eye candy, visualizations are truly very effective in many use cases – especially when rapid responses to real time findings are required or where decisions need to be made based on deep insight in trends, patterns, correlations and underlying causes.

Glance, Scan, Commit

At the heart of Oracle’s strategic design philosophy for [cloud]user experience is the ‘glance, scan, commit’ way of working we humans tend to adopt. We scan our surroundings for things that stand out in some way and therefore may require more attention. The things that attracted attention on our first scan are then glanced at – to better understand what makes them stand out, quickly interpret if action is indeed required (such as more in depth investigations, decisions or execution of a workflow or business process). Some things can perhaps be done on the fly (accept/reject, send left or right, acknowledge) and are immediately removed from the to-do list. For others we may determine that nothing further needs to be done. Then there are more involved tasks that are the end result of the scan and glance stages. These tasks form a to do list of things that we need to work on – commit ourselves to – either instantaneously or at a later moment. (see  Strategic design philosophy pushes Oracle cloud user experience to lofty new heights by Kathy Miedema for more details on this philosophy).

Glance, Scan and Commit are implemented throughout Oracle’s SaaS applications. Users typically start from an initial dashboard that provides them the information they need to perform the Glance. This is typically information that is the outcome of aggregations and advanced data analysis – resulting in condensed reports of those facts that the user needs to be aware of, needs to react to or decide upon. This information should be presented in such as way that the ‘cost of understanding is minimized’ – as Jairam Ramanathan, Senior Development Manager for Data Visualizations at Oracle Cloud and Mobility Development Tools puts it.

Usually this means that the presentation shows a recent change or trend, a comparison with a threshold, deadline or other target or a list of action items. Data Visualizations are used to present these elements in a way that makes them easy to interpret quickly and correctly. Compared with a purely textual representation, most visualizations can easily add context – such as time or location – and categorizations or grouping. Visualizations can leverage special traits of our human minds. These include our ability to quickly interpret, compare and spot differences in position, shape and size, color (to some extent) and extract a story from animation. Our brain’s associative powers quickly come into play with visualizations.

Jeremy Ashley, GVP Cloud Applications UX at Oracle and responsible for the Glance, Scan, Commit philosophy, stresses that visualizations may not be too simplistic, or our brain simply zooms out. A visualization needs to hold a certain challenge in order to pique our curiosity.

Visualizations not only cater for the glance phase, they can usually also play an important role in the scan phase. Visualizations can allow drill down, to analyze a little further and look in more details into specific areas of interest indicated during glance. Additionally, visualizations may go beyond just presenting the data and also support simple manipulation of data – for example adjusting a gauge or dragging elements on a time line or even a bubble chart. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture, Cloud Tagged with , , , , , , , ,

NEW PaaS4SaaS TOOLS: Rapid Development Kit

June 12, 2016 Leave a comment

clip_image002

 

NEW PaaS4SaaS TOOLS: The OAUX team has launched a Rapid Development Kit to help partners grow their Oracle Applications Cloud business and offer more value to customers. It’s a work in progress, but the design patterns for Release 10 are already available for download via ebook. See why user-centricity, simplicity, and consistency remain front and center in Cloud user experience designs. Check out the Forbes Oracle Voice interview with Ultan O’Broin, who leads the partner enablement effort for the OAUX team. The Voice of User Experience (VoX) blog has also published a recent post on extensibility in Release 10.

UX NEWS ON ORACLE VOICE: OAUX Group Vice President Jeremy Ashley, who leads the OAUX team, tackles new trends in the workforce and, specifically, what the OAUX team is doing in regard to mobility on Forbes.com’s Oracle Voice in Mobile UX: We’re No Longer Slaves To The System.

Simplified User Experience Design Patterns for Oracle Applications Cloud Service

This eBook contains user experience design patterns that Oracle uses to build the sleek, modern simplified user interface for the Oracle Cloud Applications portfolio, such as the Oracle ERP Cloud, Oracle HCM Cloud, and Oracle Sales Cloud. Get the free eBook here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture, Cloud Tagged with , , , , , , , , ,

HCM Atom Feed Subscriber using SOA Cloud Service by Jack Desai

May 22, 2016 Leave a comment

 

clip_image002Introduction

HCM Atom feeds provide notifications of Oracle Fusion Human Capital Management (HCM) events and are tightly integrated with REST services. When an event occurs in Oracle Fusion HCM, the corresponding Atom feed is delivered automatically to the Atom server. The feed contains details of the REST resource on which the event occurred. Subscribers who consume these Atom feeds use the REST resources to retrieve additional information about the resource.

For more information on Atom, please refer to this.

This post focuses on consuming and processing HCM Atom feeds using Oracle Service Oriented Architecture (SOA) Cloud Service. Oracle SOA Cloud Service provides a PaaS computing platform solution for running Oracle SOA Suite, Oracle Service Bus, and Oracle API Manager in the cloud. For more information on SOA Cloud Service, please refer this.

Oracle SOA is the industry’s most complete and unified application integration and SOA solution. It transforms complex application integration into agile and re-usable service-based connectivity to speed time to market, respond faster to business requirements, and lower costs.. SOA facilitates the development of enterprise applications as modular business web services that can be easily integrated and reused, creating a truly flexible, adaptable IT infrastructure.

For more information on getting started with Oracle SOA, please refer this. For developing SOA applications using SOA Suite, please refer this.

Main Article

Atom feeds enable you to keep track of any changes made to feed-enabled resources in Oracle HCM Cloud. For any updates that may be of interest for downstream applications, such as new hire, terminations, employee transfers and promotions, Oracle HCM Cloud publishes Atom feeds. Your application will be able to read these feeds and take appropriate action.

Atom Publishing Protocol (AtomPub) allows software applications to subscribe to changes that occur on REST resources through published feeds. Updates are published when changes occur to feed-enabled resources in Oracle HCM Cloud. These are the following primary Atom feeds:

Employee Feeds

New hire
Termination
Employee update

Assignment creation, update, and end date

Work Structures Feeds (Creation, update, and end date)

Organizations
Jobs
Positions
Grades
Locations

The above feeds can be consumed programmatically. In this post, Node.js is implemented as one of the solutions consuming “Employee New Hire” feeds, but design and development is similar for all the supported objects in HCM. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture, Cloud, SOA Tagged with , , , , , , , , ,

Oracle Cloud Platform: Development Workshop for Partners – Paris December 14th – 18th 2015

November 30, 2015 Leave a comment

imageThe Oracle team is pleased to invite your java developers and consultants to a 5-days hands-on workshop on how to develop, deploy and manage Java applications on Oracle Cloud platform. We invite you to join the workshop In-Class or Remotely (avoid travel time and travel costs by joining remotely).

These Invite-Only hands-on workshops will be delivered by Oracle Development at No-Fee to Partners. A workshop consists of live presentations, live demos, and hands-on laboratory exercises.

Agenda

This 5-day workshop will cover the following topics:

»   Oracle Java Cloud Service

· Develop and Manage Enterprise Java applications

· Oracle Java Cloud Administration – configure, scale, backup

· Migrate existing on-premise Java application to Oracle Java Cloud

»   Oracle Java Cloud Service – SaaS Extension

· Build Java application to seamlessly extend Oracle Cloud Applications

»  Oracle Developer Cloud Service

· Develop, Collaborate, Manage, and Deploy Code using Developer Cloud Service

»  Oracle Mobile Cloud Service

· Building Mobile Backend, Implementing Custom APIs (Node.JS)

· Offline Data Storage, Notifications, Connectors, Analytics, SDK and Mobile Application Framework Utility

Schedule & Location

December 14th – 18th 2015

Oracle Paris

15, boulevard Charles De Gaulle

92715 Colombes, France

For details please visit our registration page here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Cloud Tagged with , , , , , , , ,

PaaS and SaaS: Perfect Together by Debra Lilley

October 6, 2015 Leave a comment

clip_image001Platform as a service, or PaaS, is exciting a lot of our customers—not just those who want to move to the cloud, but also those who see PaaS as a way to build applications faster and more efficiently. As Oracle releases more development tools in the cloud, I believe that PaaS will become the de facto way to extend software as a service (SaaS).

First, let’s explore some of the major benefits of PaaS. With PaaS, you no longer have to worry about the cost and time associated with maintaining hardware or a data center. By bypassing the setup required for a development environment, your organization will achieve faster time to value on projects. Most PaaS offerings are on a consumption model: Much like buying gas, you fill up only when you need to, and you pay for only what you use. Finally, the quick-start, user-friendly, cloud-based development tools enable and foster continuous innovation.

In my work for Certus Solutions, a leader in Oracle Cloud implementations in Europe, the Middle East, and Asia, I have been particularly interested in “PaaS4SaaS,” which is the ability to extend Oracle’s cloud platform and applications with our own mini applications and have them seamlessly co-exist. Here are a few points I’ve observed for Oracle customers looking to do the same. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture, Cloud Tagged with , , , , , , , , ,

Fusion HCM Cloud Bulk Integration Automation by Jack Desai

October 5, 2015 Leave a comment

 

Introduction

clip_image002Fusion HCM Cloud provides a comprehensive set of tools, templates, and pre-packaged integration to cover various scenarios using modern and efficient technologies. One of the patterns is the bulk integration to load and extract data to/from cloud. The inbound tool is the File Based data loader (FBL) evolving into HCM Data Loaders (HDL). HDL supports data migration for full HR, incremental load to support co-existence with Oracle Applications such as E-Business Suite (EBS) and PeopleSoft (PSFT). It also provides the ability to bulk load into configured flexfields. HCM Extracts is an outbound integration tool that let’s you choose data, gathers and archives it. This archived raw data is converted into a desired format and delivered to supported channels recipients.

HCM cloud implements Oracle WebCenter Content, a component of Fusion Middleware, to store and secure data files for both inbound and outbound bulk integration patterns. This post focuses on how to automate data file transfer with WebCenter Content to initiate the loader. The same APIs will be used to download data file from the WebCenter Content delivered through the extract process.

WebCenter Content replaces SSH File Transfer Protocol (SFTP) server in the cloud as a content repository in Fusion HCM starting with Release 7+. There are several ways of importing and exporting content to and from Fusion Applications such as:

  • Upload using “File Import and Export” UI from home page navigation: Navigator > Tools
  • Upload using WebCenter Content Document Transfer Utility
  • Upload programmatically via Java Code or Web Service API

This post provides an introduction, with working sample code, on how to programmatically export content from Fusion Applications to automate the outbound integration process to other applications in the cloud or on-premise. A Service Oriented Architecture (SOA) composite is implemented to demonstrate the concept.

Main Article

Fusion Applications Security in WebCenter Content

The content in WebCenter Content is secured through users, roles, privileges and accounts. The user could be any valid user with a role such as “Integration Specialist.” The role may have privileges such as read, write and delete. The accounts are predefined by each application. For example, HCM uses /hcm/dataloader/import and /hcm/dataloader/export respectively.

Let’s review the inbound and outbound batch integration flows.

Inbound Flow

This is a typical Inbound FBL process flow: Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Filed under Architecture Tagged with , , , , , , ,

← Older posts

Newer posts →