Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Fusion PayRoll
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

Introduction

 

In one of the previous article we have tried to demonstrate how to load Worker Records in an HCM Cloud Application. Post that article got published I got multiple requests from consultants where they have asked for the actual zip files which I have used for the process.

Hence, I thought it makes sense to have a follow up article which would help the readers.

Prerequisite

While the pre-requisite details have already been mentioned in the main article but I would make a explicit mention of the same here so that ambiguity if any is removed.

The major prerequisites are:

 

  1. Creating a Source System Owner as ‘HA’
  2. Creating a Legal Employer as ‘US1 Legal Entity’
  3. Creating a Business Unit as ‘US1 Business Unit’

 

Note:

One may choose to configure different data values for Source System Owner, Legal Employer and Business Unit but in that case one would need to modify the HDL files too accordingly. As such, it still makes sense to use the existing values for now and one may try with new values later once he/she become familiar with the entire process.

 

The Effective Start Date Values used while Configuring the Source System Owner is set to 01-01-2018. If anyone chooses any values after this date they might encounter date-effectivity issues. It's recommended that the same start date value (01-01-2018) be used during the operation.

 

Sample Files

For those of you who have already gone through the article , they might have understood that we would need to perform the entire data-load procedure in 3 steps namely:

 

  1. Load Work-Structure Components
  2. Initial Worker Load
  3. Supervisor Assignments

 

A brief description of each of the above steps follows:

 

Load Work-Structure Components

One of the basic requirement before one starts creating Worker Records into the application one should ensure that the Work Structure Components like Legal Employer, Business Unit, Job, Department, Location, Grade and Position should already be present in the system. These details are required when we need to assign an individual to specific Department, Job , Location and other assignment attributes.

 

Please use the following link to download the WorkStrcutureComponents.zip file:

 

<WorkstructureComponents.zip>

 

The zip file when extracted should contain the following files:

 

 

Initial Worker Load

Once you load the WorkstructureComponents successfully one may proceed with loading the Worker Records. (These worker records would not be having supervisor related details in this load as there might be some issues with the assignment records of the supervisor and that might halt your progress). So in order to keep things simple we would load the worker details in this step and then will try to reload the supervisor details (in the third step)

 

Please use the following link to download the InitialWorkLoad.zip file:

 

<InitialWorkerLoad.zip>

 

The zip file when extracted should contain the following files:

 

 

Supervisor Assignment

After the worker load is successful, we would try to assign supervisor to the worker records.Once these files gets loaded successfully too we would be able to view that the assignment recors have the Line Manager details populated too. Also one may try to run the organization chart to view the supervisor hierarchy.

 

Please use the following link to download the SupervisorAssignment.zip file:

 

Supervisor Assignment.zip

 

The zip files when extracted should contain the following files:

 

 

Inference / Summary

Once we load all the files successfully we should be able to get an org chart (as shown below) which is a confirmation that the data-load was successful.

 


Ashish Harbhajanka

Comments   

0 #1 judionline 2022-03-24 22:28
Ahaa, its fastidious dialogue on the topic of this post here
at this webpage, I have read all that, so now me also
commenting here.
Quote
0 #2 judi 2022-05-02 18:54
I love what you guys tend to be up too. Such clever
work and reporting! Keep up the wonderful works guys I've incorporated you guys
to blogroll.
Quote
0 #3 graphene technology 2022-05-13 01:09
Hey very nice blog!
Quote

Add comment


Security code
Refresh

About the Author

Ashish Harbhajanka

 

Oracle Fusion HCM Techno Functional Consultant with overall 10 years of Experience in software industry with 5 years in EBS HRMS and rest 5 in Fusion HCM.

My areas of intesrest in Fusion HCM include :

a) Inbound Outbound Integration using FBL/HDL or BIP/HCM Extracts.

b) Fast Formula

c) BIP Reports

d) OTBI Reports

e) RESTFUL API / Web Service Call

f) Functional Setup

g) End to End Testing

h) Regression Testing

i) Preparing COnfiguration Workbooks

j) Creating Speed Solutions

k) Preparing User Guides

l) UPK

........

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner