My Oracle Support Banner

ORA-01830 Error in MSCPLD: Loader Worker With Direct Load Option while running Online Planner (Doc ID 2486357.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.9.2 to 12.1.3.9.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3.9.2 version, Memory Based Planner

Error Online Planner 64-bit Linux

When Firming a Planned Order and updating the New Date field and then running the Online Planner (Batch Replan), the MSCPLD: Loader Worker With Direct Load Option errors with the following.

ERROR
-----------------------
value used for ROWS parameter changed from 1000 to 31
Record 6619: Rejected - Error on table MSC.MSC_SUPPLIES, column EXPIRATION_DATE.
ORA-01830: date format picture ends before converting entire input string


STEPS
-----------------------
1. Run Plan
2. For a Planned Order for Item A1, Firm a Planned Order and update the New Date field to a date in the future.
3. Run Batch Replan

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.