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:

Symptoms

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

ERROR
-----------------------
Invalid date format is the error being observed

STEPS
-----------------------
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 

Cause

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