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 to [Release 12.1]
Information in this document applies to any platform.


On : 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.

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

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


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

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