Tables in Oracle HCM

 Oracle Fusion HCM (Human Capital Management) is a comprehensive suite of HR tools. 

Commonly Used HCM Tables

Here are some common examples of tables in Oracle Fusion HCM:

1. Core HR Tables

• PER_ALL_PEOPLE_F: Holds person details like name, date of birth, and hire date.
• PER_ALL_ASSIGNMENTS_F: Stores employee assignment details.
• PER_GRADES_F: Contains information about grades.
• PER_JOBS_F: Holds job information.

2. Workforce Structures

• HR_ORGANIZATION_UNITS_F: Organizational unit details.
• HR_ALL_POSITIONS_F: Information about positions.

3. Payroll Tables

• PAY_PERSONAL_PAYMENT_METHODS_F: Stores employee payment methods.
• PAY_PAYROLL_REL_ACTIONS: Information about payroll run actions.
• PAY_RUN_RESULTS: Results of payroll runs.

4. Security and User Tables

• FND_USER: Stores user account details.
• FND_USER_RESPONSIBILITY: User responsibilities.