Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Manage Time Cards 'Oracle HCM'
Summary
Manage Time Cards 'Oracle HCM'
Content
Hello,
I want to build a query in order to get the data from 'Manage Time Cards' screen.
Can you please provide me the table names to get the 'Person Name', 'Time Card period', 'Status', 'Total Hours', Recorded Hours' .....
Thanks a lot.
Answers
-
Thanks Hany, But do you have any idea about database tables that Manage Time Cards is based on?
Brgds.
0 -
Hello ,
Can you please check this out "HXT_TM_HEADER" , This table represents the timecard header available in the Webentry Timecard UI. It will hold all the header level information for the timecard like Timecard Header Comments,User Status, Resource Id, Resrouce Type
https://docs.oracle.com/cd/E51367_01/globalop_gs/OEDMH/HXT_TM_HEADER_tbl.htm
Regards
Hany Ezzat
0 -
Hello There ,
Can you look at the following URL
Regards
Hany Ezzat
0 -
Hello There ,
Please link to the following table / schema Fusion
HWM_TM_REC_GRP_SUM -- Summarized information of complex time record and time record groups
PER_PERSON_TYPE_USAGES_M -- This table is used to store the person type information for a person's relationship to the business group partition
HWM_TM_REC_GRP -- I think this table can extract Individual status
PER_ALL_PEOPLE_F -- Person names .
PER_IMAGES -- This table stores images/photos for a person .
Hope you find it all helpful .
Regards
Hany Ezzat
0 -
Hello Hany,
Thanks a lot for your appreciable help.
I did looked at HXT_TM_HEADER and i did found the Start and End Date of timecards.
Also I did linked it to PER_PERSON_NAMES table in order to get the FullName.
I did linked the table HWM_TM_STATUSES to get the statuses.
I'm still missing the other fields (See snapshot - Red)
Can you please assist and tell from where i can get those columns values
Brgds,
Mourad
0 -
Hello There ,
as far as i can tell you have to join multiple table i have posted above in order to get the proper results you are looking for ,
HWM_TM_REC_GRP_SUM -- Summarized information of complex time record and time record groups
PER_PERSON_TYPE_USAGES_M -- This table is used to store the person type information for a person's relationship to the business group partition
HWM_TM_REC_GRP -- I think this table can extract Individual status
PER_ALL_PEOPLE_F -- Person names .
PER_IMAGES -- This table stores images/photos for a person
0 -
data models aren't published. The best you'll probably get is via this link. So go to docs.oracle.com - and then click down this path. For you HCM.
You can then download spreadsheets which list all the view objects available for BI Cloud Connector extracts. Those include the table / field names. So if you use this - maybe you can find the field you want and therefore identify the table / field.
docs.oracle.com-> Cloud-->Software as a Service (SaaS)-->Product/pillar->Release->Analyze and report-> Review Data Lineage
0 -
Hi All,
I had looked above conversation . I want to extract Approver name of the employee time card. I did,t see any value that who approved the time card of employee. Do you have any idea about the approver table names in the database.
Regards,
Udhai
0 -
Hi
Did you manage to find the underlying tables linked to Time Card approvals? I'm also interested in the answer to this question.
Thanks!
Alex
0 -
Hi
Anyone managed to get the timecard approver name and the approval details.
Thanks
Razak
0
