I am trying to create a report. it is my first one using Oracle fusion.
It is a basic report on extracting employees and their salary. A payroll report.
I have already created an analysis report using the three subject areas:
- Workforce Management - Worker Assignment Real Time
- Compensation - Salary Details Real Time
- Workforce Management - Person Real Time
I like to create the same report from a data model but I am not sure which tables I need to select::
I guess it would be HCM database then to create data model I should select from FUSION.
I guess using per_person_name is one of the tables. I appreciate if you can help me in choosing the right table (and joins) to gain same result if I had chosen the three above subject areas.)
Thanks in advance