My Oracle Support Banner

DIM_CALENDAR_VALIDATOR_JOB Fails with "ORA-20001: Error occurred in RI_CALENDAR_DATA_VALIDATE.CHECK_CAL_INVALID - Check BAD_MCAL_PERIOD_DS for bad Calendar data" (Doc ID 3024590.1)

Last updated on MAY 24, 2024

Applies to:

Oracle Retail AI Foundation Cloud Service - Version 24.1 and later
Information in this document applies to any platform.

Symptoms

DIM_CALENDAR_VALIDATOR_JOB fails and log shows:

Caused by: java.sql.SQLException: ORA-20001: Error occurred in RI_CALENDAR_DATA_VALIDATE.CHECK_CAL_INVALID - Check BAD_MCAL_PERIOD_DS for bad Calendar data
ORA-06512: at \"RADM01.RI_LOG_UTIL\", line 274
ORA-06512: at \"RABE01USER.RI_CALENDAR_DATA_VALIDATE\", line 321
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at \"RABE01USER.RI_CALENDAR_DATA_VALIDATE\", line 313

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!


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