OBLM:Incorrect Next Working Date While Year Change (Doc ID 2930737.1)

Last updated on MARCH 01, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
New year date change issue.

EXPECTED BEHAVIOR
-----------------------
System should update the next working day as per the calendar setup.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
We have executed EOM where below values were presented in cmc_tm_system_dates
Today : 31-DEC-2022
PREV_WORKING_DAY : 30-DEC-2022
NEXT_WORKING_DAY : 01-JAN-2023

also for all branches we have marked all days of Jan-2023 as working

SELECT DISTINCT HOLIDAY_LIST FROM cmc_tm_local_holiday WHERE YEAR = '2023' AND MONTH = '1'
result :- WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW


SELECT DISTINCT HOLIDAY_LIST FROM cmc_tw_local_holiday WHERE YEAR = '2023' AND MONTH = '1'
result :- WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW
 
After execution of EOM we got below dates in cmc_tm_system_dates

Today : 01-JAN-2023
PREV_WORKING_DAY : 31-DEC-2022
NEXT_WORKING_DAY : 03-JAN-2023


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, incorrect dates are stamped.

Changes

Cause

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