My Oracle Support Banner

ORA-12899: value too large for column "ADMIN".&quot DJANGO_CELERY_BEAT_CRONTABSCHEDULE"."MINUTE" (actual: 69, maximum: 64). Scheduled Jobs , Contrab. (Doc ID 3026521.1)

Last updated on JUNE 05, 2024

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 24.1 and later
Information in this document applies to any platform.

Symptoms

On : 24.1 version, Scheduled Jobs


When setting up scheduled jobs type "Generate Inventory History Extract" with schedule type "Crontab" every 2 minutes the following error is raised up

ERROR
-----------------------

ORA-12899:vale too large for column
"ADMIN"DJANGO_CELERY_BEAT_CONTRABSCHEDULE"MINUTE"(actual 69, maximum:64)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. WMS >  COMP/FAC
2. Scheduled Jobs > Generate Inventory History Extract > Scheduled Type Contrab > entered 69 characters > Minute: 0,2,4,6,8,10,12,14,16,18,20,22,24,26,28,32,34,36,38,40,42,44,46,48.



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.