MSCPLD Loader Worker With Direct Load Options Errors ORA-01854 table MSC.SUPPLIESxx

(Doc ID 1930621.1)

Last updated on MAY 01, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5 and later
Information in this document applies to any platform.
Memory Based Planner

Symptoms

When attempting to run an ASCP Plan, the Loader Worker Request fails:

ERROR
--------

Record 45835: Rejected - Error on table MSC.SUPPLIES22, column OLD_WIP_START_DATE.
ORA-01854: julian date must be between 1 and 5373484

 
STEPS

--------
1. Login to Application.
2. Run ASCP Plan:
  NAV: Advanced Supply Chain Planner (R) -> Supply Chain Plan -> Launch
3. See that the plan run fails with above 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