MSCPLD Loader Worker With Direct Load Option Gets ORA-01850 ORA-01851 ORA-01861
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.
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