New Error Message added to the HCM Rapid Time Session Information Query

posted Nov 7, 2017, 9:35 AM by Barbara Thiss
A new Error Message field has been added to the far right-hand side of the HCM Rapid Time Session Information (M_TL_RAPIDTIME_SESSION_INFO) query to help identify time entries with a Date Under Report (Rpt Dt) that can cause the submitted Session to get a “No Success” error. The M_TL_RAPIDTIME_SESSION_INFO query error messages are:
  1. Rpt Dt BEFORE Position Start Date (Hire). This error means the date of the time worked is before the employee’s hire date on the Job Data screen. 
  2. Rpt Dt AFTER Term Date. This error means the date of the time worked is after the employee’s termination date on the Job Data screen. 
  3. Rpt Dt AFTER Inactive Time Rprtr Eff Date. This error means the date of the time worked is after the employee’s Inactive Time Reporter Data screen effective date. 
  4. Rpt Dt BEFORE Active Time Rprtr Eff Date. This error means the date of the time worked is before the employee’s Active Time Reporter Data screen effective date. 
The best practice is to run the M_TL_RAPIDTIME_SESSION_INFO query after you have uploaded the time entries from the Rapid Time Excel/CI Spreadsheet to the Rapid Time screen and before you submit the Rapid Time entries to Time & Labor for processing and loading onto the Timesheet screen. Download the M_TL_RAPIDTIME_SESSION_INFO query results to Excel then filter the Error Message column looking for any errors. Rapid Time entries containing errors need to be corrected before submitting them to Time & Labor otherwise they will cause the Session to fail with a “No Success” error. The Error Message field will be blank if no errors are found. If there are no errors found you can proceed with submitting the Rapid Time entries to Time & Labor for processing and loading onto the Timesheet screen.

If you have any questions about the changes to the HCM Rapid Time Session Information query please contact the Customer Service Center (CRC) by submitting a HEAT Self Service Ticket or calling 1-800-289-1500.