Skip to Main Content
Forums

Developer Community

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Which tables are used for Headcount Summary metrics in Oracle Fusion?

Hello,

I am trying to understand from which Oracle Fusion HCM tables the following Headcount Summary metrics are calculated:

  • Headcount (2.2K)
  • FTE (0.0)
  • Part Time (0.0)
  • Female Managers (54)

Could you please advise which base tables/views are used for these fields? Also, if possible, can you share a sample SQL query that shows how these metrics are retrieved?

Thank you in advance for your help.
Comments
Post Details
Added 2 days ago
1 comment
26 views