MBP Load Worker fails with ORA-01854 julian date must be between 1 and 5373484 (Doc ID 2069188.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

In a VCP 12.1.3.9.1 Instance (Decentralized APS Environment), where the destination instance is a 2 node RAC environment. When running a Manufacturing Plan (EDD Constrained Plan), with the following bucketing: 30 days, 32 weeks, and 4 periods, the 'Loader Worker With Direct Load Option' completes with the following error:
ORA-01854: julian date must be between 1 and 5373484

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