The Challenge Managers of Oracle E-Business Suite HCM applications may wish to implement a business rule that prohibits employees from taking leave that exceeds their balance (ie result in a negative leave balance). Until now, E-Business Suite has not provided an easy way to implement that business rule, rather, users needed to write custom code for the ‘BG_ABSENCE_DURATION’ fast formula. For many users these seemed overly complicated. The Solution Beginning with E-Business Suite R12.1.3, following the simple steps below, Oracle has provided a profile option that can be set to prevent employees from taking leave that exceeds their balance. Authenticate … Read More
Understanding the Core Oracle E-Business Suite HRMS Tables
There are hundreds of tables in Oracle E-Business Suite HRMS, but some are used more frequently than others. When querying, it is important to not only know the common tables that are used, but also to understand how the tables link together. Some of the common tables are listed below. Common HRMS Tables The chart above shows some of the most common tables that are used in Oracle HRMS. Often, a column in one table will link to a column in a different table. For example, the primary key PERSON_ID in the PER_ALL_PEOPLE_F table will link to the foreign key … Read More
Everything You’ve Ever Wanted to Know About HR Date-Tracking in Oracle EBS
Date-tracking is an original function through Oracle E-Business Suite (EBS) Human Capital Management (HCM). This function allows companies to edit their employees’ information and create continuity between different records. Date-tracking is an important function in EBS HCM, especially when it comes to changing employee person status, job position, etc. Correction and Update For this example, Jim Jones started as a Sales Consultant. To change information after it is entered so that instead Jim is married, use the correction function. When correcting an entry, it overrides the previous record with the error and replaces it with the new information. Therefore now it … Read More
E-Business Suite R12.1.3 HCM changes to VETS-100 Reporting
The Challenge VETS-100 reports present data for a 12 month period. Prior to R12.1.3, the E-Business Suite HCM processes used to create those reports, included parameters labelled ‘Report From Date’ and ‘Report To Date’. This allowed users to select a duration of less than 12 months. The Solution To ensure that the report covers the appropriate time span, beginning with R12.1.3, Oracle E-Business HCM functionality replaces the date fields (Report From Date and Report To Date) with the date on which the 12 months conclude: 12 Month Period End Date. The field change affects the following reports: VETS-100 Suite Of … Read More