MSCPLD Loader Worker With Direct Load Option Errors with Ora-01854 OR Ora-01861

(Doc ID 1286320.1)

Last updated on JUNE 28, 2017

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

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