My Oracle Support Banner

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.


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


A patch was applied and ASCP executable programs relinked.


To view full details, 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 a vibrant support community of peers and Oracle experts.