Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Headcount Validation OBIA HR Analytics with EBS source system
3027317
Rank 1 - Community Starter
Hi,
I want to validate the headcount field in OBIA HR analytics module with the source system data. My source system is EBS 12.1.3. Can somebody provide me the query that i can execute on source system and validate the results.
0
Answers
-
https://gist.github.com/jgilmour/4612391
^ is employee + supervisor, but has the tables you need and can be easily modified for your needs
0 -
Thanks for the query thomas. But I believe this gives me the total count. I need a count of employees that are currently working on today date and they are permanent employees
0 -
You'll have to modify the query to suit your needs ... but it contains the EBS tables you need.
0