My Oracle Support Banner

FA:SCM: SCP: Build Plan Run Error - Ora-01854: Julian Date Must Be Between 1 and 5373484 (Doc ID 2734702.1)

Last updated on JANUARY 29, 2023

Applies to:

Oracle Demand Management Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

Build Plan Archive Process for Weekly Buckets Ends in Error

####[20XX-11-22T19:17:00.708+00:00] [INFO] Execution started at : 22-Nov-20XX 19:17:00-456
 JOB PARAMETERS:
===========================================================
 Plan ID: 300000002024XXX
 Web Service Method Name: archivePlanDataForGranularityAsync
 Parent Job ID: 5553XX
 Plan Type: 1
 Granularity ID: 135
 Archive Measures : 300000008351XXX
 Archive ID: 980XX
 Archive Version: 0
 Archive Time Level ID: 291XX
===========================================================

####[20XX-11-22T19:17:08.663+00:00] [INFO] Job Completion Status : Business Error Job Completion Message : ORA-01854: julian date must be between 1 and 5373484

Biz Error Message: ORA-01854: julian date must be between 1 and 5373484

Execution completed at : 22-Nov-20XX 19:17:08-642
 

ERROR
-----------------------
ORA-01854: julian date must be between 1 and 5373484

Changes

 

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
Changes
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.