Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« April 2012 | Main | July 2012 »

June 28, 2012

PeopleSoft to Taleo Integration - An Approach (Part 2)

Guest post by
Neha Barnawal, Senior Associate Consultant, Infosys


In the first part of the blog one of the approaches to integrate Taleo Talent Acquisition and Performance Management modules with Peoplesoft Core HR module is outlined which involves imparting the Peoplesoft data to Taleo via an outbound Interface.

A further description is as below.

Interface Description

Different files with following information will be generated by the Interface:

  • Employee
  • Job
  • Cost Center
  • Department
  • Users: Other than regular employees\
  • Location
  • Compensation unit
  • Feed to Taleo Performance Management

Business Rules for creating the output

Business rules for the population implemented in each files are as below:


  • All Regular Employees
  • The latest information from the primary job record


  • Active Job codes
  • Job attributes such as Grade, Over Time Eligibility, Frequency and Salary Admin Plan

Cost Center

  • Active Cost Centers
  • Cost Center attributes such as Cost Center managers, Business unit


  • Active Departments
  • Department attributes such as Department Manager, Business unit

Other Users 

  • All Temporary employees with Taleo Recruiter Roles: Taleo recruiter roles mapped to the Peoplesoft security roles
  • Temporary employees can be a recruiter for the organization when they are subcontracted or temporarily hired for specialized recruitments


  • All active work locations

Compensation Unit

  • All active compensation units(SAL_ADMIN_PLAN in PS ) and its details

Feed to Taleo Performance Management

  • All regular employees with HR status as 'Active' or 'Leave'
  • Terminated employees since the last time information from PS has been entered into Taleo
  • Translation and mapping of PSFT roles and conditions to Taleo Recruitment and Performance roles


PS to Taleo2.jpgThe above approach can be used for any Taleo to PeopleSoft integration by incorporating the right set of assumptions, extension of the business rules and functionality of the Interface.

Further Scope

The interface can be extended to the reporting and analytics processes also. An Inbound Interface will be required for Peoplesoft if the data flow has to happen from Taleo to PS.

June 13, 2012

Oracle Mobile Supply Chain Applications : Be Mobile, Be Quick, Be Accurate and Reduce Waste

Guest post by
Shantanu Bedekar, Senior Consultant, Infosys


Anyone who has visited a manufacturing plant or a warehouse knows that there is always a time-lag between physical movement of material and recording the same in the system. The unavoidable reason of this is: material is stored in racks, bins, containers spread across the warehouse or shop-floor but computer terminals on which Oracle forms are opened to enter data are far and few.

Often this leads to:

  1. Reduced efficiency and utilization of warehouse personnel and devices - Imagine a discrete job shop where each job needs 20 to 30 components from different locations. And John, who is working in warehouse for last 30 years is supposed to pick and kit material on a trolley for a lot of jobs every shift and move that trolley in the queue of the machine on which first operation will be performed. Now John comes at the start of the shift, picks up 'job pick lists' printed on a designated printer, puts them in a rack, picks up the first one, goes around the warehouse, picks each component from the locator printed on the 'pick list', marks picked quantity on the 'pick list', if component is picked from a different locator or picked from multiple locators, John writes the locator name and quantity in the space that is actually not available anywhere  on that 'pick slip'. After doing all this stuff, he comes back to the 'terminal' that has Oracle form open. But as soon as he enters the job number, it tells him that a re-login is required as the system is idle for some time. And when eventually John succeeds in opening 'WIP Material transaction form', he has to take care of locator changes, components that he did not pick etc. etc. And then repeat this for the next job and so on. Now wonder why John is not happy with the new system?
  2. Inventory accuracies - if John forgets to enter transaction in the system, the inaccuracies remain until they are corrected by way of cycle counting or physical counting. By the time the inaccuracies are corrected, it has already impacted supply demand picture thus creating noise in the planning system.
  3. At any point of time, a discrepancy between actual inventory positions vis-à-vis system inventory picture - though the discrepancies get corrected within a short span when John perform transactions in the system, it restricts the plant from going for 'continuous cycle counting' and requires setting aside a specific window within a day or shift to perform counting. This in turn reduces the 'utilization percentage of the shift'.

Another common complaint is: how did Oracle allow this transaction? For e.g. if a subinventory has locator control as 'dynamic locator', it will allow John to enter any locator in the receiving form which physically does not exist. Or John moves item 12X000001 but in the system enters 12X000002 in the item field which is also stored on the same locator. John's supervisor logs a support ticket and you give above explanations. Supervisor comes back and says, 'Hey, John is not an Engineer. And the guy is working here for 30 years. Give him a system which is simple and error proof!'

So what can you suggest? Train John so that he doesn't make any mistakes? Put computer terminals on each rack OR at least in each row in the warehouse? Give him a faster 'forklift' to 'blitzkrieg' around the shop-floor? Well, you can suggest a simpler solution: use Oracle Mobile Supply Chain Applications.

Oracle Mobile Supply Chain Applications provides functionality to perform various material transactions using Radio Frequency enabled mobile/handheld devices. John can perform transaction right where he is picking or putting the material, sitting in his fork-lift or at the receiving dock unloading material from the truck. Handheld devices come with barcode readers and when provided with enough barcodes on various pick lists and on the storage locations, it gives great relief to John who now just need to click and not enter the tedious part numbers or locators with 4 trailing dots because 'locator KFF' has 4 segments but locators are defined with a value in only first segment. Thus John now doesn't need to shuttle between warehouse racks and the 'Oracle Terminal' and worry about entering wrong part numbers or locators.

For the plant managers, improved inventory accuracy helps in better output of supply chain planning, supply chain execution and on-time delivery and reduces (and eventually eliminates) noise in material movement execution. It also enables them to opt for continuous cycle counting thereby increasing shift utilization.

MSCA is a 'Green' solution that helps in reducing carbon footprint - with MSCA, an organization can reduce 'computer terminals' on the floor that are always switched-on and can also minimize movement of personnel/material handling devices in a manufacturing facility by providing means of data entry at the point of consumption. 

Oracle MSCA is easy to implement and easy to use. It is like an extension of the Oracle forms and allows users to perform common Inventory, Manufacturing and Quality Inspection transactions such as:

  • Subinventory transfers
  • Cycle count entry
  • Issue material to work orders
  • Complete work orders
  • Receive material and Deliver to Stock against Purchase orders or internal requisitions
  • Inspect during receiving, WIP move or WIP completion
  • Pick and Ship against sales or internal orders
  • and many more...

MSCA can be used as a stepping stone before moving to complex material management systems such as Oracle Warehouse Management System. When an organization decides to move to WMS, the efforts required in change management, training are less as users are familiar with using handheld devices. Also the infrastructure investment in RF network, devices, MWA server etc. is already in place, tested and ready to use.

June 1, 2012

PeopleSoft to Taleo Integration - An Approach (Part 1)

Guest post by
Neha Barnawal, Senior Associate Consultant, Infosys


Talent Management contributes to the backbone of any of the HRMS system and its market has been evolving over time. As per a report from Bersin & Associates- a specialist research firm- an amount of more than $3 billion has been spent by the organizations to buy talent management softwares in 2011 and this number is expected to increase by 16-17% in 2012.

Peoplesoft to Taleo Integration

Why Taleo? Taleo has been preferred by the organizations to a great extent due to its cloud based solution, offering tremendous vendor capacities and unrivaled functionality in Recruitment and Performance Management functions.

Why Peoplesoft? Peoplesoft is valued for Core HR business processes extensively.

Why Taleo-Peoplesoft Integration? With the market trending towards cloud based solutions, there is a substantial requirement to integrate the disjoint best of the breed HRMS systems catering to various HR processes. After the acquisition of Taleo by Oracle, the scope for integration of both the systems eventually intensifies.

Below is one of the approaches to integrate Taleo Talent Acquisition and Performance Management modules with Peoplesoft Core HR module, in form of outbound interface, imparting the Peoplesoft data to Taleo.


Data feed

For the Taleo Recruitment module, data has to be fed to Taleo for Cost Center and Cost Center Managers, Departments, Locations, Recruitment Managers and Employees information.

The feeds will be in form of files generated by an interface. A specific file with Peoplesoft job data will be fed to be used in Taleo application for Requisition creation and its management and also for accessing the internal job postings.

An additional file including personal data, job data and security roles of the employees will be fed to Taleo Performance Management which shares the information with the Recruiting module. Taleo Performance Management will use this information for Performance Reviews and Talent Management processes to enable employees to access their Performance Review data and talent management team to manage the entire Talent Management and Performance Review processes.

Taleo Connect Client- Taleo integration tool

The data from Peoplesoft will be extracted in files and uploaded into Taleo using Taleo Connect Client (TCC). TCC is a part of Taleo Connect suite which is used to integrate Taleo with other organizational systems like HR Operations, HR Information System, Reporting, Analytics and Core HR systems. Technically, TCC is utilized as an integration tool to deal with the information flow in form of Interfaces to/from the Taleo system.

PS-Taleo.jpgThe subsequent post (part-2) will outline the description and business rules for the Interface and its output. It will also brief the future scope of this approach.

Subscribe to this blog's feed

Follow us on

Blogger Profiles

Infosys on Twitter