Hello! Can anyone help me? What are the tables that contain the information in the Time module?
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.
HWM_TM_REC_GRP
https://docs.oracle.com/en/cloud/saas/human-resources/25b/oedmh/hwmtmrecgrp-7973.html
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
We are encountering issues with our OTBI dashboards where there is no option to export to Excel. This seems to be a new issue after the latest update to 26B. I made a change to the report layout (moved one analysis into its own section), and now I cannot export the page. As you can see in my attached photos, the export…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
