Oracle Fusion 11g - analysis vs report using DataModel


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
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sorry - but to which Oracle Fusion product you are refering to:

DB structure is ALL YOURS, none of Fusion-label products makes one for you.
shmzAuthor Commented:
It is a business intelligence, developing reports and analysis. Relational databases not data warehouses and on a cloud based environment.

2) Since data is your design - please show related DDL, No way to guess what you are at without it.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

shmzAuthor Commented:
Obviously I was not and am not sure about your question and provided all I knew.
This is a Oracle fusion Human capital management (HCM) application we use in our company. It has a feature to develop reports.
It is a cloud based so I have not or do not know how to access it!
When I develop a report, I choose the HCM database as a source.

Have I answered your question?
How many different report development tool does Oracle have?
shmzAuthor Commented:
As per link you provided it should be:
Business Analytic
OK you hold the keys with your attention request so I cannot ask to re-shuffle TAs.

Oracle Fusion is commonly understood as fusion middleware - weblogic application server.
Given mention of cloud I would bet on version 12c (where 11g stood for grid and 10i for internet)
What you have is one of hundred or so applications that run on top of that weblogic server, each of them with own reports tool.
Best that can be done is getting on TAs regarding oracle forms design, and getting out of databases, web app servers etc technical stuff.
I don't know about the application but within the database you can search

dba_tab_cols or all_tab_cols  to find which columns are in which tables.

Using a tool like oracle's sql developer (free) you can browse the objects you have access to.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shmzAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.