How to integrate Oracle EBS HRMS with ADP system

Oracle EBS has come a long way, starting with version 10.6 Character User Interface with Database Version 5 in 1995. EBS HRMS is a worldwide recognized and widely accepted application – tool – system for the past few decades with the help of which business user(s) across the globe can organize employee data effectively and efficiently. They can perform activities such as hire/re-hire/terminate/change on the data at any point of time as per the business requirement.

The business aspect of the integration

This blog tells us more about the integration in terms of steps, challenges, and advantages.

Step1: It covers business requirement aspect only – Understand various types and levels of an employee in the ADP system. The type will decide what the activity required for an employee is. It will add an employee– to update employee information – to-re hire an employee and terminate an employee.

Each level comprises various mandatory and optional components.
Level 1 will be the employee header.
Level 2 will be the employee assignment level.

This step involves rigorous interaction with super user(s) since they will deal with the end product once the system is live – up and running.

Most importantly, this step will also decide what the prerequisites on the Oracle EBS side are. Once the data starts flowing – it should fit exactly as per the business requirement – less hiccups in the post-production era. This step is purely based on discussion(s), which happens in terms of F2F (onsite team) and/or con calls (onsite/offshore team). Learn more Oracle Integration partners

Step2: It covers both functional and technical aspects of the integration, which will decide the file layout. This step will map an employee's mandatory and/or optional components with the Oracle EBS HRMS system. This step will be the basis or act as an input to this integration.

Step3: It covers the system's technical aspect – Load the ADP data in Oracle staging – validate it – call the Oracle API to load the validated data in base tables. The output will show correct & erroneous data to be rectified. Corrected data will follow the same process, which is load – validate – populate in this integration.

Challenge: To date, employee information was being stored in Oracle EBS HRMS only, and now it will flow from the ADP system to Oracle, i.e., reverse engineering.

ADP being a new system, the first and foremost task is to sync prerequisite data from Oracle in ADP, which is master data, so that when data will flow from ADP to Oracle, which is transactional data (employee data), it will not mess up and create problem(s) in the future. Most importantly, this data is confidential, so we need to be very careful playing around with it.

Synchronization (existing Oracle EBS HRMS to ADP) consists of the following entities

  • Employee data, including supervisor (which in itself is an employee)
  • Organization
  • Job title
  • Position
  • Grade

Advantages

Having this systematic approach saves a considerable amount of time and, most crucial, helps super users know right from the beginning what is being developed for them. It is part of their training as well. Secondly, mapping is done early, not to miss even a single component once we develop the integration.

Mobile World

The technical aspect of the integration

  • Load the pipe-delimited data from ADP into Oracle staging using SQL*Loader
  • Validate the data using PL/SQL
  • Call Oracle seeded API(s) to populate the base tables

Database: 12c CLOUD
EBS: R12.2.10

Comments

  1. Arpita Raj12 August 2021 at 03:56

    Excellent article and this helps to enhance your knowledge regarding new things. Waiting for more updates.
    Salesforce Technology
    Salesforce Data Integration Tools

    ReplyDelete

Post a Comment

Popular posts from this blog

Whitepaper - Mobile Application Testing

With the advent of smartphones, a mobile phone has evolved from being just a communication device to a highly sophisticated business utility equipment. With smartphones no longer remaining a conspicuous consumption, they have become an efficient tool for handling finances, managing mails & agendas, and executing other business functions. Statistics highlight that 1.6 billion smart phones are sold at a rate of 1.8 to 2 million devices a day since 2007, and 1.5 billion smartphones will be shipped in 2016 – a 5.7 percent increase from 2015 – and will reach 1.92 billion by 2020. Download whitepaper - Mobile application testing
Read more

Tableau CRM features and Setup guide

Image
What is Tableau CRM? Many enterprises have leveraged Salesforce out-of-the-box reports and dashboards to understand their data and performance for years. However, data size has been increasing rapidly daily; analyzing the data manually has become a bigger challenge; subsequently, analytics have become more critical than ever before. Learn more about Salesforce CRM implemetation   Tableau CRM (Formerly known as Einstein Analytics) was introduced to address this challenge. It's an AI (Artificial intelligence) powered advanced analytics solution which works with any data source. The AI-powered Einstein Discovery, Einstein Analytics apps analyze billions of data combinations and provide predictive insights and prescriptive recommendations to the users. Tableau CRM provides analytic experiences in sales, service, and marketing to quickly take business decisions and actions. This platform is also optimized for mobile use. Why Tableau CRM? The key differences between Tableau C...
Read more

5 Things You Must Know About Cyber Security in the Cloud

Image
At first cloud computing and cyber security look like they are not related to each other. However, we can see that they are related and the reason behind it is that the first requires storing your data off-site and the second requires building virtual walls around it, protecting your data at all costs. Cloud computing means outsourcing, trusting a vendor to keep your data and transactions safe. Cyber security means keeping it all close, trusting the staff, procedures and protocols to do the job. Check more information about Oracle Cloud Managed Services . Cloud Security is the new Cyber Security With every passing year, the number of businesses migrating to the cloud increases–and the number of cyberattacks increases, as if keeping pace. By end of 2018, almost 96 percent of organizations started using cloud computing in some way, according to CIO.com. At the same time, cyberattacks were on the rise, with almost twice as many ransomware attacks in 2017 (160,000) as compared t...
Read more