Understanding the Core Oracle E-Business Suite HRMS Tables

Shannon MiskevicsOracle2 Comments

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

Shannon MiskevicsOracle, Technical TipsLeave a Comment


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