Hi Leonardo,

Have a look at

Oracle Fusion Cloud HCM Tables and Views for HCM G26438-01 25B

https://docs.oracle.com/en/cloud/saas/human-resources/25b/oedmh/index.html

Chapter 27 Time and Labor

Also use SQL to query the following 4 subject areas to get information about business process "Report Time", "Approve Time", and "Transfer Time" of approved timecards to payroll and expenses (processed timecards).

Oracle Fusion Cloud HCM
Subject Areas for Transactional Business Intelligence in HCM G26460-01 25B

https://docs.oracle.com/en/cloud/saas/human-resources/25b/faohb/Workforce-Management-Reported-Time-Cards-Real-Time-SA-274.html

Workforce Management - Reported Time Cards Real Time
Workforce Management - Processed Time Cards Real Time
Workforce Management - Historical Reported Time Cards Real Time
Workforce Management - Historical Processed Time Cards Real Time

Review the data lineage to review what presentation tables and columns in the metadata repository database (logical) are available to query along with their mapping to view objects to the source transaction tables and views in the application database (physical). Use View Log on page Issue SQL or Manage Sessions to view the sql generated for your query along with data security where clauses added.

Oracle Fusion Cloud HCM
Tables and Views for HCM
G26438-01 25B

HWM_TM_REC_GRP

https://docs.oracle.com/en/cloud/saas/human-resources/25b/oedmh/hwmtmrecgrp-7973.html