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 |