My Oracle Support Banner

MDS Load with Forecast Explosion OR Copy/Merge Forecast with Explosion Fails with Error - mrlgjda_local_get_julian_date failed due to ORA-01841 (Doc ID 2621584.1)

Last updated on JANUARY 19, 2022

Applies to:

Oracle Materials Requirement Planning - Version 12.2.4 and later
Information in this document applies to any platform.


On : 12.1.x or 12.2.X version, Forecast

When attempting to run Oracle planning forecast explosion, it results in failure,
the following error occurs.


Cause: mrlgjda_local_get_julian_date failed due to ORA-01841: (full) year must be between -4713 and +9999, and not be 0

The issue can be reproduced at will with the following steps:
1. /Edit / Preferences / Profile - Set profile MRP: debug mode - Yes at user level
2. Material Planner / MDS / Names - Load/Copy/Merge - pick MDS name t and parameters to include Explode - Yes and launch request
   OR Forecast / Copy - Pick forecast and parameters to include Explode - Yes and launch request
3. Log file shows error



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

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