My Oracle Support Banner

MSCPLD Loader Worker With Direct Load Option Errors with Ora-01854 OR Ora-01861 (Doc ID 1286320.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

Memory Based Planner

When attempting to launch ASCP plan for the first time, the loader worker is failing with error

-----------------------
Log file could shows two different errors.

Error
------

MSCPLD module: Loader Worker With Direct Load Option

Record 1: Rejected - Error on table MSC.MSC_DEMANDS, column PROMISE_DATE.
ORA-01861: literal does not match format string

OR you might see

Record 70: Rejected - Error on table MSC.MSC_DEMANDS, column PROMISE_DATE.
ORA-01854: julian date must be between 1 and 5373484


STEPS
-----------------------
1. Responsibility : Advanced supply chain planning
2. Navigation : Supply chain planning > Launch
3. Loader worker fails with error

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
Cause
Solution


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