MSCPLD Loader Worker With Direct Load Option Gets ORA-01850 ORA-01851 ORA-01861 (Doc ID 1349708.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Memory Based Planner

When attempting to run ASCP Plan,the following error occurs in Loader Worker With Direct load Option

Record 219: Rejected - Error on table MSC.MSC_SUPPLIES, column NEED_BY_DATE.
ORA-01851: minutes must be between 0 and 59

Record 1: Rejected - Error on table MSC.MSC_DEMANDS, column USING_ASSEMBLY_DEMAND_DATE.
ORA-01850: hour must be between 0 and 23

Record 353045: Rejected - Error on table MSC.MSC_EXCEPTION_DETAILS, column DATE1.
ORA-01861: literal does not match format string

Changes

A patch was applied and ASCP executable programs relinked.

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