collective agreement white paper

2011 TransSys Solutions - Confidential

Using Oracle Collective

Agreement

Sandip JadhavArun Rekha

Agenda

• About TransSys Solutions • About Supreme Group• Collective Agreement Requirements• Setup Steps• Additional Steps for Payroll Processing• Q & A

2011 TransSys Solutions - Confidential2

About TransSys Solutions

• Niche Information Technology Consulting organization that focuses on enabling variety of organizations in the Middle East & Africa region adopt ERP Solutions effectively

• Oracle Gold Partner formed by group of consultants who among themselves carries over 50 person years of experience in ERP Implementation, Program and Project Management, Bolt-on solutions development and deployment with specialization across Airlines, BFSI, Telecom and Retail verticals

2011 TransSys Solutions - Confidential3

About TransSys Solutions

Specialties• Oracle E-Business Suite• Oracle BI Apps,• ERP Implementations Upgrades and Support• Advanced Technology solutions• Oracle Application Testing Suite (OATS)

2011 TransSys Solutions - Confidential4

About TransSys Solutions

• Website http://www.transsyssolutions.com• Head Quarters5G & 5F, GEE GEE Emarald Village Road, Nungambakkam Chennai,Tamilnadu600088 India

2011 TransSys Solutions - Confidential5

About Supreme Group

• Founded in 1957, Supreme Group is a multinational organization specializing in providing customized supply chain and associated service solutions in some of the world’s most challenging and remote locations

• The Group operates in more than 20 countries throughout Africa, Asia, Europe, the Americas and the Middle East and is a provider of food, fuel, transportation, logistics and support services

2011 TransSys Solutions - Confidential6

About Supreme Group

• Supreme Group currently employs over 8,800 direct staff, comprising more than 70 nationalities

• The Group continues to support and serve high profile clients including the United Nations (UN), the North Atlantic Treaty Organization (NATO), the UK Ministry of Defence (MoD), the US Department of Defense (DoD), the German Bundeswehr, Turkish Airlines, Maersk, KFC and Subway.

2011 TransSys Solutions - Confidential7

Collective Agreement Requirements

2011 TransSys Solutions - Confidential8

• Hardship allowance is provided to employees Located in Afghanistan based on Grade criteria

Setup Steps

• Define Earnings• Define Element Links• Define Eligibility Profiles• Define Collective Agreements• Define Collective Agreement Entitlement and Rates• Assign Entitlements to Group of Employees or• Assign Entitlements to Single Employee

2011 TransSys Solutions - Confidential9

Define Earnings

Navigation: UAE HRMS Manager Total Compensation Basic Element Description

2011 TransSys Solutions - Confidential10

Input ValuesNavigation: UAE HRMS Manager Total Compensation Basic Element

Description Input Values(Button)

2011 TransSys Solutions - Confidential11

Define Element Links

Navigation: UAE HRMS Manager Total Compensation Basic Link

2011 TransSys Solutions - Confidential12

PLSQL for Fast Formula – Grade 1 to 5• FUNCTION get_afghan_hardship_1to5_elig (• p_assign_id IN NUMBER,• p_business_group_id IN NUMBER,• p_effective_date IN DATE• ) RETURN VARCHAR2 IS• CURSOR cur_grade IS• SELECT get_grade_from_assign_id (p_assign_id,• p_business_group_id,• p_effective_date• ),• get_location_from_assign_id (p_assign_id,• p_business_group_id,• p_effective_date• )• FROM DUAL;• ln_grade NUMBER;• lv_location VARCHAR2 (30);• BEGIN• OPEN cur_grade;• FETCH cur_grade• INTO ln_grade, lv_location;• CLOSE cur_grade;• IF ln_grade BETWEEN 1 AND 5 AND lv_location = 'Afghanistan'• THEN RETURN 'Y';• ELSE RETURN 'N';• END IF;• END get_afghan_hardship_1to5_elig;

2011 TransSys Solutions - Confidential13

PLSQL for Fast Formula – Grade 6 to 16• FUNCTION get_afghan_hardship_6to16_elig (• p_assign_id IN NUMBER,• p_business_group_id IN NUMBER,• p_effective_date IN DATE• ) RETURN VARCHAR2 IS• CURSOR cur_grade IS• SELECT get_grade_from_assign_id (p_assign_id,• p_business_group_id,• p_effective_date• ),• get_location_from_assign_id (p_assign_id,• p_business_group_id,• p_effective_date• )• FROM DUAL;• ln_grade NUMBER;• lv_location VARCHAR2 (30);• BEGIN• OPEN cur_grade;• FETCH cur_grade• INTO ln_grade, lv_location;• CLOSE cur_grade;• IF ln_grade BETWEEN 6 AND 16 AND lv_location = 'Afghanistan'• THEN RETURN 'Y';• ELSE RETURN 'N';• END IF;• END get_afghan_hardship_6to16_elig;

2011 TransSys Solutions - Confidential14

Define Formula Function

Navigation – UAE HRMS Manager Other Definitions Formula Functions

2011 TransSys Solutions - Confidential15

Define Context Usages

Navigation – UAE HRMS Manager Other Definitions Formula Functions Context Usages(Button)

2011 TransSys Solutions - Confidential16

Define Formula Function

Navigation – UAE HRMS Manager Other Definitions Formula Functions

2011 TransSys Solutions - Confidential17

Define Context Usages

Navigation – UAE HRMS Manager Other Definitions Formula Functions Context Usages(Button)

2011 TransSys Solutions - Confidential18

Fast Formula – Grade 1 to 5

Navigation – UAE HRMS Manager Total Compensation Basic Write Formulas• /***************************************************************• FORMULA NAME: BEN_HARDSHIP_1TO5_ELIGIBILITY_AFGHAN• FORMULA TYPE : Participation and Rate Eligibility• DESCRIPTION : The formula checks if the employee is eligible for Afghan Grade 1 to 5• ***************************************************************• Change History:• ----------------------------------------------------------------• Sandip Jadhav 31-Dec-2012 Initial Version• ****************************************************************• FORMULA TEXT: Logic in simple terms.• ****************************************************************/• eligible =BEN_HARDSHIP_1TO5_ELIGIBILITY_AFGHAN()• return ELIGIBLE• /*================ FORMULA SECTION END =======================*/

2011 TransSys Solutions - Confidential19

Fast Formula – Grade 6 to 16

Navigation – UAE HRMS Manager Total Compensation Basic Write Formulas• /***************************************************************• FORMULA NAME: BEN_HARDSHIP_6TO16_ELIGIBILITY_AFGHAN• FORMULA TYPE : Participation and Rate Eligibility• DESCRIPTION : The formula checks if the employee is eligible for Afghan Grade 6 to 16• ***************************************************************• Change History:• ----------------------------------------------------------------• Sandip Jadhav 31-Dec-2012 Initial Version• ****************************************************************• FORMULA TEXT: Logic in simple terms.• ****************************************************************/• eligible =BEN_HARDSHIP_6TO16_ELIGIBILITY_AFGHAN()• return ELIGIBLE• /*================ FORMULA SECTION END =======================*/

2011 TransSys Solutions - Confidential20

Define Eligibility Profiles – Grade 1 to 6

Navigation: UAE HRMS Manager Work Structures Collective Agreement Define Eligibility Profiles

2011 TransSys Solutions - Confidential21

Define Eligibility Profiles – Grade 6+

Navigation: UAE HRMS Manager Work Structures Collective Agreement Define Eligibility Profiles

2011 TransSys Solutions - Confidential22

Define Collective Agreement

Navigation: UAE HRMS Manager Work Structures Collective Agreement Define Collective Agreement

2011 TransSys Solutions - Confidential23

Define Entitlement Rates

Navigation: UAE HRMS Manager Work Structures Collective Agreement Define Collective Agreement Entitlements(Button)

2011 TransSys Solutions - Confidential24

Assign Collective Agreement

Navigation – UAE HRMS Manager People Enter and Maintain Assignments(Button)

2011 TransSys Solutions - Confidential25

Assign Entitlements to Group

Navigation – UAE HRMS Manager Processes and Reports Submit Processes and Reports Single Request Collective Agreement Entitlement Evaluation

2011 TransSys Solutions - Confidential26

Collective Agreement Entitlement Evaluation• Can be run in one of the three process modes 1. Apply Only 2. Evaluate and Apply 3. Evaluate Only• Can be run in one of the three Processing Levels 1. Single Assignment 2. Single Collective Agreement 3. Single Entitlement Item• Validate Mode – Commit or No Commit

2011 TransSys Solutions - Confidential27

Assignment Entitlements to Single EmployeeNavigation – UAE HRMS Manager People Enter and Maintain Assignment

Others Agreement and Grade Results

2011 TransSys Solutions - Confidential28

Element Entries

Navigation – UAE HRMS Manager People Enter and Maintain Assignment Entries

2011 TransSys Solutions - Confidential29

Element Entry Values

Navigation - UAE HRMS Manager People Enter and Maintain Assignment Entries Entry Values

2011 TransSys Solutions - Confidential30

Tips

• Use of collective agreements apply to primary assignments only

• Earliest Start Date for collective agreement is 01-Jan-1953

• For Eligibility profiles, use the function under the collective agreement menu

• An element and input value combination can be used for single entitlement only

2011 TransSys Solutions - Confidential31

Reference Document

• Oracle Human Resources Management Systems Enterprise and Workforce Management Guide Release 12.1 (Part Number E13540-06)

2011 TransSys Solutions - Confidential32

2011 TransSys Solutions - Confidential33

Q & A

Contact Us

• Sandip Jadhav Sandip.jadhav@transsyssolutions.com

• Arun Rekha Arunarekha.P@transsyssolutions.com

2011 TransSys Solutions - Confidential34

35

About TransSys Solutions TransSys Solutions is a young and agile start-up entity focusing on Enterprise Applications based on Oracle Universe of solutions and technology. Founded by professionals with significant experience and insight of the Middle East & Africa market and the customer expectations, TransSys focuses on delivering transformational value to the customers in their pursuit of enterprise solutions. Our service offerings are defined by our core theme enable.enhance.extract©

2011 TransSys Solutions - Confidential