My Oracle Support Banner

Enter Hours And Time In And Out (Mixed Format) On The Same Day Results In Incorrect Total (Doc ID 1390654.1)

Last updated on SEPTEMBER 30, 2019

Applies to:

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


When attempting to create self service Payroll timecard, get error :

DBD-OTL-Err-001 Please correct your time entry. Your weekly total worked and non-worked hours must equal to 40 hours .
Please contact your system administrator

Timecard with Start Stop hours 16:30 (HH:MM) and
hours type with totals 7.39 (Decimal time )

Calculates total of 37 hours and 179.4 minutes
which is calculated in Decimal  time = 39.98333333333333333333333333333333333335 hours

Time Entry Rule Period Hours vs Time Category (Seeded Formula)
HXC_TIME_CATEGORY_Comparison has operator = Not Equal to
Period maximum = 40

The way self service timecard and FF function rounds decimal hours is not the same


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.