You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTL - Time card approval details stored in which table

Received Response
edited Jul 6, 2019 12:20PM in Workforce Management 11 comments


Hello Team,


i have requirement to pull the below mentioned details in Oracle time labor module for time card entered.




am able to get the person number, name and Time period, Total recorded hours from HWM_TM_REC_GRP_SUM_V. now problem is that from this table am not able to find link for HXT_APRV_TXN_DETAILS where this table has the links to soa work flow tables.


what is the intermediate table i should use to establish the link.


and do we have any table to know about additional status details like payroll processing.



M Vijayalakshm

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!