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 laterInformation 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 |