EDD Constrained Without Detailed Scheduling Plan MSCPLD - Loader Worker With Direct Load Option Fails ORA-01854: Julian Date Must Be Between 1 And 5373484
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.
On : 12.2.4 version, Memory Based Planner
Users are on 12.2.4 and have applied 220.127.116.11 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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms