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



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



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


http://www.transsyssolutions.com/

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


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.


Collective Agreement Requirements


• 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


Define Earnings

Navigation: UAE HRMS Manager Total Compensation Basic Element Description


Input ValuesNavigation: UAE HRMS Manager Total Compensation Basic Element

Description Input Values(Button)


Define Element Links

Navigation: UAE HRMS Manager Total Compensation Basic Link


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;


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;


Define Formula Function

Navigation – UAE HRMS Manager Other Definitions Formula Functions


Define Context Usages

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


Define Formula Function

Navigation – UAE HRMS Manager Other Definitions Formula Functions


Define Context Usages

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


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 =======================*/


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 =======================*/


Define Eligibility Profiles – Grade 1 to 6

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


Define Eligibility Profiles – Grade 6+

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


Define Collective Agreement

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


Define Entitlement Rates

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


Assign Collective Agreement

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


Assign Entitlements to Group

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


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


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

Others Agreement and Grade Results


Element Entries

Navigation – UAE HRMS Manager People Enter and Maintain Assignment Entries


Element Entry Values

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


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


Reference Document

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



Q & A

Contact Us

• Sandip Jadhav [email protected]

• Arun Rekha [email protected]


mailto:[email protected]

mailto:[email protected]

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

collective agreement white paper

Documents