My Oracle Support Banner

Fusion Time and Labor: 24B DBI FOR HWM_PUB_SCHD_ALL_START_TIME Not Returning hours From Rule (Doc ID 3024884.1)

Last updated on MAY 24, 2024

Applies to:

Oracle Fusion Time and Labor Cloud Service - Version 11.13.24.04.0 and later
Information in this document applies to any platform.

Symptoms

DBI FOR HWM_PUB_SCHD_ALL_START_TIME Not Returning hours From Rule

Customers who use Database Items (DBIs) to get Shift/Schedule information in Time and Labor Rules might not get data returned. This could cause Time Cards to go into error or it could result in incorrect calculation, if the rules are used to calculate a different rate for hours worked outside the schedule.

The issue would affect customers that are using the DBIs to look for schedules between two date and time intervals. For example, in order to get schedule for May 24th, 2024, if the rule is looking for schedule information between 05/24/2024 00:00:00 and 05/24/2024 23:59:59

This doesn't affect scenarios where the DBIs are used to look for schedules for a day or for data between two day intervals. For example, in order to get schedule for May 24th, 2024, if the rule is looking for schedule information between 05/24/2024 00:00 and 05/25/2024 00:00:00. This is also the recommended way to look for schedules.

The issue could affect rules that are using the following database items (DBIs):

HWM_EMP_SCHD_ALL_ALLOW_OVERTIME_FLAG
HWM_EMP_SCHD_ALL_END_EARLY_ERR_TYPE
HWM_EMP_SCHD_ALL_END_EARLY_GRACE_PERIOD
HWM_EMP_SCHD_ALL_END_GRACE_BEGIN
HWM_EMP_SCHD_ALL_END_GRACE_END
HWM_EMP_SCHD_ALL_END_LATE_ERR_TYPE
HWM_EMP_SCHD_ALL_END_LATE_GRACE_PERIOD
HWM_EMP_SCHD_ALL_END_TIME
HWM_EMP_SCHD_ALL_END_TOLERANCE_BEGIN
HWM_EMP_SCHD_ALL_END_TOLERANCE_END
HWM_EMP_SCHD_ALL_IS_ELAPSED_SHIFT
HWM_EMP_SCHD_ALL_LONG_DURATION
HWM_EMP_SCHD_ALL_PREMIUM_SHIFT_CODE
HWM_EMP_SCHD_ALL_SHIFT_INCENTIVE_AMOUNT
HWM_EMP_SCHD_ALL_SHORT_DURATION
HWM_EMP_SCHD_ALL_START_EARLY_ERR_TYPE
HWM_EMP_SCHD_ALL_START_EARLY_GRACE_PERIOD
HWM_EMP_SCHD_ALL_START_GRACE_BEGIN
HWM_EMP_SCHD_ALL_START_GRACE_END
HWM_EMP_SCHD_ALL_START_LATE_ERR_TYPE
HWM_EMP_SCHD_ALL_START_LATE_GRACE_PERIOD
HWM_EMP_SCHD_ALL_START_TIME
HWM_EMP_SCHD_ALL_START_TOLERANCE_BEGIN
HWM_EMP_SCHD_ALL_START_TOLERANCE_END
HWM_EMP_SCHD_ALL_TOLERANCE
HWM_EMP_SCHD_ALL_WORKFORCE_SHIFT_TYPE
HWM_EMP_SCHD_ALL_WORKFORCE_SHIFT_TYPE_CLASS
HWM_EMP_SCHD_ALL_WORKFORCE_SHIFT_TYPE_CODE
HWM_EMP_SCHD_ALLOW_OVERTIME_FLAG
HWM_EMP_SCHD_END_EARLY_ERR_TYPE
HWM_EMP_SCHD_END_EARLY_GRACE_PERIOD
HWM_EMP_SCHD_END_GRACE_BEGIN
HWM_EMP_SCHD_END_GRACE_END
HWM_EMP_SCHD_END_LATE_ERR_TYPE
HWM_EMP_SCHD_END_LATE_GRACE_PERIOD
HWM_EMP_SCHD_END_TIME
HWM_EMP_SCHD_END_TOLERANCE_BEGIN
HWM_EMP_SCHD_END_TOLERANCE_END
HWM_EMP_SCHD_IS_ELAPSED_SHIFT
HWM_EMP_SCHD_LONG_DURATION
HWM_EMP_SCHD_PREMIUM_SHIFT_CODE
HWM_EMP_SCHD_SHIFT_INCENTIVE_AMOUNT
HWM_EMP_SCHD_SHORT_DURATION
HWM_EMP_SCHD_START_EARLY_ERR_TYPE
HWM_EMP_SCHD_START_EARLY_GRACE_PERIOD
HWM_EMP_SCHD_START_GRACE_BEGIN
HWM_EMP_SCHD_START_GRACE_END
HWM_EMP_SCHD_START_LATE_ERR_TYPE
HWM_EMP_SCHD_START_LATE_GRACE_PERIOD
HWM_EMP_SCHD_START_TIME
HWM_EMP_SCHD_START_TOLERANCE_BEGIN
HWM_EMP_SCHD_START_TOLERANCE_END
HWM_EMP_SCHD_TOLERANCE
HWM_EMP_SCHD_WORKFORCE_SHIFT_TYPE
HWM_EMP_SCHD_WORKFORCE_SHIFT_TYPE_CLASS
HWM_EMP_SCHD_WORKFORCE_SHIFT_TYPE_CODE
HWM_EXT_PUB_SCHED_ALL_ALLOW_OVERTIME_FLAG
HWM_EXT_PUB_SCHED_ALL_ASSIGNMENT_ID
HWM_EXT_PUB_SCHED_ALL_DURATION
HWM_EXT_PUB_SCHED_ALL_END_DATE
HWM_EXT_PUB_SCHED_ALL_END_EARLY_PERIOD
HWM_EXT_PUB_SCHED_ALL_END_EARLY_VIOLATION_TYPE
HWM_EXT_PUB_SCHED_ALL_END_LATE_PERIOD
HWM_EXT_PUB_SCHED_ALL_END_LATE_VIOLATION_TYPE
HWM_EXT_PUB_SCHED_ALL_END_TIME
HWM_EXT_PUB_SCHED_ALL_GRACE_PERIOD
HWM_EXT_PUB_SCHED_ALL_LONG_DURATION
HWM_EXT_PUB_SCHED_ALL_PREMIUM_SHIFT_CODE
HWM_EXT_PUB_SCHED_ALL_REFERENCE_DATE
HWM_EXT_PUB_SCHED_ALL_SHIFT_CODE
HWM_EXT_PUB_SCHED_ALL_SHIFT_DESC
HWM_EXT_PUB_SCHED_ALL_SHIFT_ID
HWM_EXT_PUB_SCHED_ALL_SHIFT_INCENTIVE_AMOUNT
HWM_EXT_PUB_SCHED_ALL_SHIFT_NAME
HWM_EXT_PUB_SCHED_ALL_SHIFT_SHORT_CODE
HWM_EXT_PUB_SCHED_ALL_SHIFT_SHORT_NAME
HWM_EXT_PUB_SCHED_ALL_SHIFT_TYPE
HWM_EXT_PUB_SCHED_ALL_SHORT_DURATION
HWM_EXT_PUB_SCHED_ALL_START_DATE
HWM_EXT_PUB_SCHED_ALL_START_EARLY_PERIOD
HWM_EXT_PUB_SCHED_ALL_START_EARLY_VIOLATION_TYPE
HWM_EXT_PUB_SCHED_ALL_START_LATE_PERIOD
HWM_EXT_PUB_SCHED_ALL_START_LATE_VIOLATION_TYPE
HWM_EXT_PUB_SCHED_ALL_START_TIME
HWM_EXT_PUB_SCHED_ALL_TIME_NOT_WORKED
HWM_EXT_PUB_SCHED_ALL_UPDATED
HWM_EXT_PUB_SCHED_ALL_WORKFORCE_SHIFT_TYPE
HWM_EXT_PUB_SCHED_ALL_WORKFORCE_SHIFT_TYPE_CLASS
HWM_EXT_PUB_SCHED_ALL_WORKFORCE_SHIFT_TYPE_CODE
HWM_EXT_PUB_SCHED_ALLOW_OVERTIME_FLAG
HWM_EXT_PUB_SCHED_ASSIGNMENT_ID
HWM_EXT_PUB_SCHED_DURATION
HWM_EXT_PUB_SCHED_END_DATE
HWM_EXT_PUB_SCHED_END_EARLY_PERIOD
HWM_EXT_PUB_SCHED_END_EARLY_VIOLATION_TYPE
HWM_EXT_PUB_SCHED_END_LATE_PERIOD
HWM_EXT_PUB_SCHED_END_LATE_VIOLATION_TYPE
HWM_EXT_PUB_SCHED_END_TIME
HWM_EXT_PUB_SCHED_GRACE_PERIOD
HWM_EXT_PUB_SCHED_LONG_DURATION
HWM_EXT_PUB_SCHED_PREMIUM_SHIFT_CODE
HWM_EXT_PUB_SCHED_REFERENCE_DATE
HWM_EXT_PUB_SCHED_SHIFT_CODE
HWM_EXT_PUB_SCHED_SHIFT_DESC
HWM_EXT_PUB_SCHED_SHIFT_ID
HWM_EXT_PUB_SCHED_SHIFT_INCENTIVE_AMOUNT
HWM_EXT_PUB_SCHED_SHIFT_NAME
HWM_EXT_PUB_SCHED_SHIFT_SHORT_CODE
HWM_EXT_PUB_SCHED_SHIFT_SHORT_NAME
HWM_EXT_PUB_SCHED_SHIFT_TYPE
HWM_EXT_PUB_SCHED_SHORT_DURATION
HWM_EXT_PUB_SCHED_START_DATE
HWM_EXT_PUB_SCHED_START_EARLY_PERIOD
HWM_EXT_PUB_SCHED_START_EARLY_VIOLATION_TYPE
HWM_EXT_PUB_SCHED_START_LATE_PERIOD
HWM_EXT_PUB_SCHED_START_LATE_VIOLATION_TYPE
HWM_EXT_PUB_SCHED_START_TIME
HWM_EXT_PUB_SCHED_TIME_NOT_WORKED
HWM_EXT_PUB_SCHED_UPDATED
HWM_EXT_PUB_SCHED_WORKFORCE_SHIFT_TYPE
HWM_EXT_PUB_SCHED_WORKFORCE_SHIFT_TYPE_CLASS
HWM_EXT_PUB_SCHED_WORKFORCE_SHIFT_TYPE_CODE
HWM_PUB_SCHD_ALL_ACTIVITY_TYPE
HWM_PUB_SCHD_ALL_ALLOW_OVERTIME_FLAG
HWM_PUB_SCHD_ALL_DATE_FROM
HWM_PUB_SCHD_ALL_DATE_TO
HWM_PUB_SCHD_ALL_MEASURE
HWM_PUB_SCHD_ALL_ORDER_ENTERED
HWM_PUB_SCHD_ALL_PREMIUM_SHIFT_CODE
HWM_PUB_SCHD_ALL_REC_SOURCE
HWM_PUB_SCHD_ALL_SHIFT_CODE
HWM_PUB_SCHD_ALL_SHIFT_ENTRY_SOURCE
HWM_PUB_SCHD_ALL_SHIFT_INCENTIVE_AMOUNT
HWM_PUB_SCHD_ALL_SHIFT_NAME
HWM_PUB_SCHD_ALL_SHIFT_OWNER
HWM_PUB_SCHD_ALL_SHIFT_TYPE
HWM_PUB_SCHD_ALL_START_TIME
HWM_PUB_SCHD_ALL_STOP_TIME
HWM_PUB_SCHD_ALL_SUBRESOURCE_ID
HWM_PUB_SCHD_ALL_TCSMR_CONFIG_SET_ID
HWM_PUB_SCHD_ALL_TCSMR_SET_ID
HWM_PUB_SCHD_ALL_TIME_NOT_WORKED
HWM_PUB_SCHD_ALL_TM_REC_ID
HWM_PUB_SCHD_ALL_TM_REC_TYPE
HWM_PUB_SCHD_ALL_TM_REC_VERSION
HWM_PUB_SCHD_ALL_UNIT_OF_MEASURE
HWM_PUB_SCHD_ALL_WORKFORCE_SHIFT_TYPE
HWM_PUB_SCHD_ALL_WORKFORCE_SHIFT_TYPE_CLASS
HWM_PUB_SCHD_ALL_WORKFORCE_SHIFT_TYPE_CODE
HWM_PUB_SCHD_ACTIVITY_TYPE
HWM_PUB_SCHD_ALLOW_OVERTIME_FLAG
HWM_PUB_SCHD_DATE_FROM
HWM_PUB_SCHD_DATE_TO
HWM_PUB_SCHD_MEASURE
HWM_PUB_SCHD_ORDER_ENTERED
HWM_PUB_SCHD_PREMIUM_SHIFT_CODE
HWM_PUB_SCHD_REC_SOURCE
HWM_PUB_SCHD_SHIFT_CODE
HWM_PUB_SCHD_SHIFT_ENTRY_SOURCE
HWM_PUB_SCHD_SHIFT_INCENTIVE_AMOUNT
HWM_PUB_SCHD_SHIFT_NAME
HWM_PUB_SCHD_SHIFT_OWNER
HWM_PUB_SCHD_SHIFT_TYPE
HWM_PUB_SCHD_START_TIME
HWM_PUB_SCHD_STOP_TIME
HWM_PUB_SCHD_SUBRESOURCE_ID
HWM_PUB_SCHD_TCSMR_CONFIG_SET_ID
HWM_PUB_SCHD_TCSMR_SET_ID
HWM_PUB_SCHD_TIME_NOT_WORKED
HWM_PUB_SCHD_TM_REC_ID
HWM_PUB_SCHD_TM_REC_TYPE
HWM_PUB_SCHD_TM_REC_VERSION
HWM_PUB_SCHD_UNIT_OF_MEASURE
HWM_PUB_SCHD_WORKFORCE_SHIFT_TYPE
HWM_PUB_SCHD_WORKFORCE_SHIFT_TYPE_CLASS
HWM_PUB_SCHD_WORKFORCE_SHIFT_TYPE_CODE
HWM_DTL_SCHD_ALL_ACTIVITY_TYPE
HWM_DTL_SCHD_ALL_ALLOW_OVERTIME_FLAG
HWM_DTL_SCHD_ALL_DATE_FROM
HWM_DTL_SCHD_ALL_DATE_TO
HWM_DTL_SCHD_ALL_END_EARLY_ERR_TYPE
HWM_DTL_SCHD_ALL_END_EARLY_TOLERANCE_PERIOD
HWM_DTL_SCHD_ALL_END_GRACE_BEGIN
HWM_DTL_SCHD_ALL_END_GRACE_END
HWM_DTL_SCHD_ALL_END_LATE_ERR_TYPE
HWM_DTL_SCHD_ALL_END_LATE_TOLERANCE_PERIOD
HWM_DTL_SCHD_ALL_END_TIME
HWM_DTL_SCHD_ALL_END_TOLERANCE_BEGIN
HWM_DTL_SCHD_ALL_END_TOLERANCE_END
HWM_DTL_SCHD_ALL_GRACE
HWM_DTL_SCHD_ALL_IS_ELAPSED_SHIFT
HWM_DTL_SCHD_ALL_LONG_DURATION
HWM_DTL_SCHD_ALL_ORDER_ENTERED
HWM_DTL_SCHD_ALL_PREMIUM_SHIFT_CODE
HWM_DTL_SCHD_ALL_SCHEDULED_DURATION
HWM_DTL_SCHD_ALL_SCHEDULED_REF_DATE
HWM_DTL_SCHD_ALL_SCHEDULED_SHIFT_CODE
HWM_DTL_SCHD_ALL_SCHEDULED_SHIFT_COLOUR
HWM_DTL_SCHD_ALL_SCHEDULED_SHIFT_DESC
HWM_DTL_SCHD_ALL_SCHEDULED_SHIFT_NAME
HWM_DTL_SCHD_ALL_SCHEDULED_SHIFT_SHORT_CODE
HWM_DTL_SCHD_ALL_SCHEDULED_SHIFT_SHORT_NAME
HWM_DTL_SCHD_ALL_SCHEDULED_TIME_NOT_WORKED
HWM_DTL_SCHD_ALL_SHIFT_INCENTIVE_AMOUNT
HWM_DTL_SCHD_ALL_SHIFT_TYPE_ID
HWM_DTL_SCHD_ALL_SHORT_DURATION
HWM_DTL_SCHD_ALL_START_EARLY_ERR_TYPE
HWM_DTL_SCHD_ALL_START_EARLY_TOLERANCE_PERIOD
HWM_DTL_SCHD_ALL_START_GRACE_BEGIN
HWM_DTL_SCHD_ALL_START_GRACE_END
HWM_DTL_SCHD_ALL_START_LATE_ERR_TYPE
HWM_DTL_SCHD_ALL_START_LATE_TOLERANCE_PERIOD
HWM_DTL_SCHD_ALL_START_TIME
HWM_DTL_SCHD_ALL_START_TOLERANCE_BEGIN
HWM_DTL_SCHD_ALL_START_TOLERANCE_END
HWM_DTL_SCHD_ALL_SUBRESOURCE_ID
HWM_DTL_SCHD_ALL_TCSMR_CONFIG_SET_ID
HWM_DTL_SCHD_ALL_TCSMR_SET_ID
HWM_DTL_SCHD_ALL_TM_REC_ID
HWM_DTL_SCHD_ALL_TM_REC_TYPE
HWM_DTL_SCHD_ALL_WORKFORCE_SHIFT_TYPE
HWM_DTL_SCHD_ALL_WORKFORCE_SHIFT_TYPE_CLASS
HWM_DTL_SCHD_ALL_WORKFORCE_SHIFT_TYPE_CODE
HWM_DTL_SCHD_ACTIVITY_TYPE
HWM_DTL_SCHD_ALLOW_OVERTIME_FLAG
HWM_DTL_SCHD_DATE_FROM
HWM_DTL_SCHD_DATE_TO
HWM_DTL_SCHD_END_EARLY_ERR_TYPE
HWM_DTL_SCHD_END_EARLY_TOLERANCE_PERIOD
HWM_DTL_SCHD_END_GRACE_BEGIN
HWM_DTL_SCHD_END_GRACE_END
HWM_DTL_SCHD_END_LATE_ERR_TYPE
HWM_DTL_SCHD_END_LATE_TOLERANCE_PERIOD
HWM_DTL_SCHD_END_TIME
HWM_DTL_SCHD_END_TOLERANCE_BEGIN
HWM_DTL_SCHD_END_TOLERANCE_END
HWM_DTL_SCHD_GRACE
HWM_DTL_SCHD_IS_ELAPSED_SHIFT
HWM_DTL_SCHD_LONG_DURATION
HWM_DTL_SCHD_ORDER_ENTERED
HWM_DTL_SCHD_PREMIUM_SHIFT_CODE
HWM_DTL_SCHD_SCHEDULED_DURATION
HWM_DTL_SCHD_SCHEDULED_REF_DATE
HWM_DTL_SCHD_SCHEDULED_SHIFT_CODE
HWM_DTL_SCHD_SCHEDULED_SHIFT_COLOUR
HWM_DTL_SCHD_SCHEDULED_SHIFT_DESC
HWM_DTL_SCHD_SCHEDULED_SHIFT_NAME
HWM_DTL_SCHD_SCHEDULED_SHIFT_SHORT_CODE
HWM_DTL_SCHD_SCHEDULED_SHIFT_SHORT_NAME
HWM_DTL_SCHD_SCHEDULED_TIME_NOT_WORKED
HWM_DTL_SCHD_SHIFT_INCENTIVE_AMOUNT
HWM_DTL_SCHD_SHIFT_TYPE_ID
HWM_DTL_SCHD_SHORT_DURATION
HWM_DTL_SCHD_START_EARLY_ERR_TYPE
HWM_DTL_SCHD_START_EARLY_TOLERANCE_PERIOD
HWM_DTL_SCHD_START_GRACE_BEGIN
HWM_DTL_SCHD_START_GRACE_END
HWM_DTL_SCHD_START_LATE_ERR_TYPE
HWM_DTL_SCHD_START_LATE_TOLERANCE_PERIOD
HWM_DTL_SCHD_START_TIME
HWM_DTL_SCHD_START_TOLERANCE_BEGIN
HWM_DTL_SCHD_START_TOLERANCE_END
HWM_DTL_SCHD_SUBRESOURCE_ID
HWM_DTL_SCHD_TCSMR_CONFIG_SET_ID
HWM_DTL_SCHD_TCSMR_SET_ID
HWM_DTL_SCHD_TM_REC_ID
HWM_DTL_SCHD_TM_REC_TYPE
HWM_DTL_SCHD_WORKFORCE_SHIFT_TYPE
HWM_DTL_SCHD_WORKFORCE_SHIFT_TYPE_CLASS
HWM_DTL_SCHD_WORKFORCE_SHIFT_TYPE_CODE

 

Cause

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
Symptoms
Cause
Solution
References


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