The Feature

Sample DataLoad Templates for Oracle HRMS

July 19, 2006 on 9:58 pm | by Marian Crkon | In How To Guides | 2 Comments |  Print |  Email

DataLoad is a good option to upload data from Excel to Oracle Applications when other options, like Web ADI, are not available. DataLoad is practical when the volume of data to upload is too small to justify creating a custom script with the use of Oracle APIs, or too big to do it manually (let’s say between 10 and 1,000 records).

Below are several sample DataLoad templates for Oracle Human Resources (HRMS) I used before, with their descriptions and navigation instructions. Note that these are only samples. You may need to modify the spreadsheets based on your application configurations. The blue columns represent DataLoad commands, the yellow columns is where you paste your data. Hope you will find the templates useful.

Create HR Organizations

Create HR organization names and their classifications.

Navigation: US HRMS Manager: Work Structures > Organization > Description

Start Field: Name

DataLoad: Create HR Organizations

Create HR Organization Hierarchy

Create organization hierarchy, define parent organizations and their subordinates.

Navigation: US HRMS Manager: Work Structures > Organization > Description

Start Field: Name

DataLoad: Create HR Organization Hierarchy

Update Employee Email Addresses

Update employee email addresses in HR. This email address is used to route Workflow notifications via email and must be the same as employees primary address in your mail server (e.g. MS Outlook) if your Oracle WF Mailer configuration does not allow forwarding of email responses (see the Do Not Forward Oracle Notifications from Outlook! story).

Navigation: US HRMS Manager: People > Enter and Maintain

Start Field: Full Name in the Find Person window

DataLoad: Update Employee Email Addresses

Transfer Employees

Oracle Human Resources provides several flexible options to mass update employees and employee assignments. However, when transferring employees between organizations, you can only update their HR organizations and not their Default Purchasing Information when using Mass Updates. The Purchasing Information is critical for accurate approvals and accounting of employee requisitions and expense reports. This is where DataLoad came in handy.

Navigation: US HRMS Manager: People > Enter and Maintain

Start Field: Full Name in the Find Person window

DataLoad: Transfer Employees