• Oracle Value Sets
    No Comments on Oracle Value Sets

    Value Set is a collection of values. It validates the values entered by the user for a flex-field, report parameters or a concurrent.   The navigation path: System Administrator- Application-ValidationSets  Why do we need value sets?   You do not always want a user to enter junk free text into all the fields. Hence, Oracle…

    Read more
  • Appraisal Competency Score FF
    No Comments on Appraisal Competency Score FF

    Formula Name : AVG_COMP_AND_OBJ  *  * Description  : This takes the average of the competency and  *                objective scores and then uses this to  *                determine the final rating.  *  * Formula Type : Appraisal Total Scoring  *  * Inputs       : 1) competency_score, number, always set  *                2) objective_score, number, always set  *                3) appraisal_id,…

    Read more
  • SQL Query – How to Calculate Net Pay
    No Comments on SQL Query – How to Calculate Net Pay

    To Find out Employee wise Organization SELECT haou.name, papf.employee_number, papf.full_name FROM per_all_people_f papf, per_all_assignments_f paaf, hr_all_organization_units haou WHERE 1 = 1 AND papf.person_id = paaf.person_id AND paaf.organization_id = haou.organization_id AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date GROUP BY haou.name, papf.employee_number, papf.full_name Single Latest Balance Table Upgrade: The latest…

    Read more
  • Payroll Tables
    No Comments on Payroll Tables

    PAYROLL TABLES Payroll does not deal with a lot of tables, in comparison with other modules like Benefits / Core-HR. So the idea was to go through the functional set ups first and then look at the technical aspects, and peep through the tables. PAY_ELEMENT_TYPES_F: No need to say, that this is a date track…

    Read more
  • Oracle HRMS: Bulk Upload Employees in Oracle HRMS from Excel
    No Comments on Oracle HRMS: Bulk Upload Employees in Oracle HRMS from Excel

    Oracle EBS- How to create EmployBulees in Oracle HRMS from an Excel File Oracle has a powerful Excel based tool- Web ADI- Web Application Desktop Integrator which can be used with some simple set up to upload data into Oracle HRMS and create Employees. Oracle also offers some integration tools and Application Programming Intefaces – APIs….

    Read more
  • BG Absence Duration FF
    No Comments on BG Absence Duration FF

    /*FORMULA NAME: TEMPLATE_ABSENCE_DURATIONFORMULA TYPE: QuickpaintDESCRIPTION:  Calculates the Employee’s Absence              Duration in days or hours. The profile              ‘HR: Absence Duration Auto Overwrite’              determines if an existing duration value              can change automatically or…

    Read more
  • How to config and use WebADI?
    4 Comments on How to config and use WebADI?

    How to config and use WebADI? Prerequisites for Web ADI on client machine ■ Internet Explorer 5.0 or greater installed on your machine; Make the user’s browser security settings will allow a spreadsheet to be created on the desktop. 1. Navigate to Tools > Internet Options and choose the Security tab. 2. Select Local Intranet…

    Read more
  • Absence Management – Setups
    No Comments on Absence Management – Setups

    Absence Management setup steps Navigation: Global HRMS Manager > Total Compensation >Basic > Element Description 1. Define an element Name and Description 2. Select the classification as Earning or Information 3. Select the type as ‘Non Recurring’ 4. Select the termination rule ‘Actual Termination, final close or Last Standard process’ 5. Select the option Multiple…

    Read more
  • Oracle Payroll – Retro Pay – Proration Setups
    No Comments on Oracle Payroll – Retro Pay – Proration Setups

    Retro Pay setups:=================1. Create a main Element/ Link2. Create a child Element(Retro)/ Link3. Attach the child Element to the Main Element4. Create Event Group and attach to the Main Element under “Recalculation Tab”5. Create emp and do the correction on the element input values6. Create Assignment Set & Element Set7. Run “Retro Notification Report”8. Run…

    Read more

Back to Top