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

Has anyone worked on retrieving the Payroll Process status from Timecards?

in Help Desk

Summary:

As shown in the image shared below, there is a table HWM_TM_REC_GRP_SUM that has a payroll process column, but it does not store any data.

Oracle Support and OTBI suggested using the function hwm_timecard_utils.get_entry_pay_proc_status(TIME_ENTRY.TM_REC_ID, TIME_ENTRY.TM_REC_VERSION). It works for up to 5,000 records, but if it exceeds 5,000 records, it causes performance issues and eventually errors out.

If anyone has worked on this before, could you please share any reference SQL or ideas?

Thanks in advance.

Content (please ensure you mask any confidential information):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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