My Oracle Support Banner

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:

Oracle Advanced Supply Chain Planning - Version 12.2.6 and later
Information 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


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