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
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
