Memory Based Planner 64-bit Linux - Loader Worker With Direct Load Option Completing In Error (Doc ID 2497031.1)

Last updated on OCTOBER 16, 2019

Applies to:

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

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