New error conditions added to the M_TL_RAPIDTIME_SESSION_INFO query for Rapid Time

posted Dec 10, 2018, 5:02 PM by Peyri Herrera
NEW!

For Rapid Time users.

Effective December 10, 2018, new error conditions have been added to HCM Rapid Time Session Information (M_TL_RAPIDTIME_SESSION_INFO) query to help identify time entries with a Date Under Report (Rpt Dt) that is either 1 or more months after or 6 months or more before today's date. Future dates have caused several Rapid Time sessions to fail due to not having supporting configurations set for those future date calendars. Dates 6 months or older are more of a warning to verify the Date Under Report (Rpt Dt) is correct.

The new M_TL_RAPIDTIME_SESSION_INFO query error messages are:
  • Rpt Dt 1 month or more AFTER today. This error means the date of the time worked is 1 month or more after today's date. 
  • Rpt Dt 6 months or more BEFORE today. This error means the date of the time worked is 6 months or more before today's date. 
As a reminder, 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. 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.