Memory Based Planner 64-bit Linux - Loader Worker With Direct Load Option Completing In Error
(Doc ID 2497031.1)
Last updated on APRIL 04, 2022
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
Memory Based Planner 64-bit Linux - Loader Worker With Direct Load Option Completing in Error
The Memory Based Planner 64-bit Linux child job, Loader Worker With Direct Load Option is completing with an error. Here is the error message in the Loader Worker log file:
ERROR
value used for ROWS parameter changed from 1000 to 143
SQL*Loader-643: error executing INSERT statement for table MSC.MSC_BIS_INV_DETAIL#
ORA-03113: end-of-file on communication channel
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
Specify SKIP=1686534 when continuing the load.
Table MSC.MSC_BIS_INV_DETAIL#:
1686534 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
STEPS
The issue can be reproduced at will with the following steps:
1. Navigation: Advanced Supply Chain Planner > Supply Chain Plan > Launch
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 |