It is very essential for the enterprise to store organizational data along with employee data, and use them to manage the people related to the enterprise effectively. This requirement creates the market for a system called the Human Resource Management System.

Oracle E-Biz provides a very effective and scalable way to manage the Human Resource of an enterprise. It is called Oracle human Resource Management System (a.k.a Oracle HRMS / Oracle HCM). Oracle HRMS as a whole is a combination of few Sub Modules. Each sub module supports one particular type of application / practice.

How does SF integration implemented using Oracle SOA?

Types of integration that we at LogiCoy have accomplished with SOA are as follows:

SuccessFactors to Oracle HRMS integration
Non managed Person info integration
Integration from HRMS to Success Factor
SF to Oracle HRMS integration: The architectural representation of SF to HRMS system is depicted below.

SuccessFactors is integrated with Oracle HRMS for the modules:

Employee (Person information)

Assignment Information

Assignment costing

Salary details

Absence Information

Outdoor duty details

Labor card details

Contact information

Phone details

Separation details

Payment method information

Visa details

Passport details

Element Entries

Company transport details

All the above data integrations are done in two modes. To describe, one is when an new employee/person information is created in SF, this new employee details has to be immediately created/reflected in Oracle HRMS system. And the second one is update mode when the subsequent employee details have to be updated for an existing employee.

The SOA integration system receives the input in the form of an encrypted file which the SOA system receives, decrypts and parses and applies business logic to update to HRMS system using a HRMS Oracle API call. The data transformation and mapping to HRMS is handled for the employee in SOA integration layer.

Employee information transformation pic:

The SOA integration layer continuously monitors for any employee information creation and/or updates and immediately transforms and syncs data to HRMS system.

The below are the pics of other employee sub data which are transformed and synced to HRMS system.

Assignment Information transformation pic:

Assignment costing transformation pic:

Salary details transformation pic:

Element Entries transformation pic:

Error handling and Report generation:

Unlike in monolithic applications, error handling becomes a significant step in the design of SOA applications as SOA applications integrate heterogeneous IT systems across the organizational boundaries, vendor and partner IT assets. Focusing on error handling analysis early in the analysis and design phases ensures that appropriate error handling standards/guidelines are put in place for modules in different platforms.

During SF-HRMS integration, whenever there are errors found either while transforming data or synchronizing data with HRMS system, such errors are handled, captured and reported using a SOA integrated reporting service. The error reporting BPEL process flow is depicted below.

Error reporting BPEL process flow pic:

Oracle to SF integration for non managed employee information:

Integration of non managed employee: This part of the SOA integration monitors data from a custom oracle table for employee details and generates an outbound XML files for creation of employee details in SF.

2. Non managed employee details transformation pic:

3. Integration from HRMS to SF:

Oracle system’s specific legacy data from HRMS is integrated to SF for seamless and less transformation functionality.

To know more about Logicoy SAP SuccessFactors to Oracle HRMS integration, please visit https://logicoy.com/successfactors-to-oracle-hrms-integration/