Employee Salary Tables in Oracle Fusion

 Employee Salary Tables in Oracle Fusion

Hi friends, we are going to discuss about the Employee Salary Tables in Oracle Fusion. We will share some of the most important employee salary tables in oracle fusion which helps to store the employee salary and its element related information in oracle fusion. If i will compare with oracle apps , employee tables are completely changed in oracle fusion. There are many employee salary related tables but there are some of the tables which stores most of the important data related to employee salary elements. If we need to get the employee salary , then we need to get the different salary elements which makes the complete salary for the employee. So we except , salary will be stored in one table or we can get the complete salary details only from one column then its completely wrong. To fetch the employee salary from backend then it evolves multiple tables and in these tables we need to add the multiple salary elements to finally get the employee salary in oracle fusion. Please find below the complete Employee Salary Tables in Oracle Fusion.

Employee Salary Tables in Oracle Fusion

Top 6 Employee Salary Tables in Oracle Fusion

1.CMP_BASIS_COMPONENTS

2.CMP_BASIS_PAY_RATES

3.CMP_BASIS_SIMPLE_COMPONENTS

4.CMP_ASG_SALARY_COMPONENTS_V

6.CMP_ASG_SALARY_V

Here below is the Detail Employee Salary query in Oracle Fusion

Here below is the detail sql query which helps to extract the complete employee salary information's in oracle fusion. You can use these below 3 sql queries using this you can extract the employee salary related information's in oracle fusion.

Query 1:- 

select person_id from per_all_people_f where person_number = '[PERSON_NUMBER]'

Query 2:-

select assignment_id, assignment_number from per_all_assignments_m where person_id in ([PERSON_ID from Q1])

Query 3:-

select * from cmp_salary where assignment_id in ([ASSIGNMENT_ID from Q2])

Employee Salary Tables in Oracle Fusion