EDD Constrained Without Detailed Scheduling Plan MSCPLD - Loader Worker With Direct Load Option Fails ORA-01854: Julian Date Must Be Between 1 And 5373484 (Doc ID 2021088.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Memory Based Planner

Users are on 12.2.4 and have applied 12.2.4.1 VCP Patch 19549533.  Users are running an EDD Constrained Without Detailed Scheduling MRP/Mfg plan with an MPS/Master plan defined as the demand schedule. However the MRP plan is erroring with the following in MSCPLD: Loader Worker With Direct Load Option

value used for ROWS parameter changed from 1000 to 40
Record 4: Rejected - Error on table "MSC"."MSC_DEMANDS#", column USING_ASSEMBLY_DEMAND_DATE.
ORA-01854: julian date must be between 1 and 5373484

The MPS/MPP Demand Schedule plan completes fine
EDD constrained with detailed scheduling produces the same error.

THe plan has one org, one MPP item that should drive demand in the MRP plan.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup the MPS Plan and run it, it runs fine
2. Setup the MRP Plan with the MPS Plan as the Demand Schedule, Loader Worker completes in error in the specific cases mentioned above

Cause

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 hundreds of Community platforms