My Oracle Support Banner

Mass Time Entry Upload Issues When Start_time And Stop_time Entered In hh:mm aa Format (Doc ID 2801385.1)

Last updated on JULY 18, 2022

Applies to:

Oracle Time and Labor - Version 12.2.9 and later
Information in this document applies to any platform.


While uploading the csv template, getting date format error, even though correct date format of hh:mm aa was passed.

Invalid date format is the error being observed

The issue can be reproduced at will with the following steps:

1. From SS Time entry (The Menu is 'Time Upload Standard Menu' you may have to add to your responsibility). export the mass time entry CSV file.
2. Navigate to Mass Time Upload
3. Provide Start_time and Stop_time in hh:mm aa Format
4. Upload file > click Review > click Stage Data
5. Observe the error and record will not be uploaded in interface table 



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.