Loader Worker With Direct Option Ending In Error (Doc ID 2058936.1)

Last updated on APRIL 20, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

MSCPLD: Loader Worker With Direct Load Option (12.2) fails with:

The following index(es) on table MSC.SUPPLIES2049 were processed:
index MSC.SUPPLIES_N1_2049 loaded successfully with 652701 keys
index MSC.SUPPLIES_N2_2049 loaded successfully with 652701 keys
index MSC.SUPPLIES_N3_2049 loaded successfully with 652701 keys
index MSC.SUPPLIES_N4_2049 loaded successfully with 652701 keys
index MSC.SUPPLIES_N5_2049 loaded successfully with 652701 keys
index MSC.SUPPLIES_N6_2049 loaded successfully with 652701 keys
index MSC.SUPPLIES_N7_2049 loaded successfully with 652701 keys
index MSC.SUPPLIES_N8_2049 loaded successfully with 652701 keys
index MSC.SUPPLIES_U1_2049 loaded successfully with 652701 keys

Table MSC.SUPPLIES2049:
  652701 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.

  Date conversion cache disabled due to overflow (default size: 1000)

Bind array size not used in direct path.
Column array rows : 1000
Stream buffer bytes: 256000
Read buffer bytes: 1048576

Total logical records skipped: 0
Total logical records read: 652701
Total logical records rejected: 0
Total logical records discarded: 0
Total stream buffers loaded by SQL*Loader main thread: 1363
Total stream buffers loaded by SQL*Loader load thread: 400

Run began on Wed Jul 29 15:41:57 2015
Run ended on Wed Jul 29 15:42:35 2015

Elapsed time was: 00:00:38.73
CPU time was: 00:00:21.14

Error string=
Statement with the error:
declare v_sql_stmt VARCHAR2 ( 4000 ) ; lv_partition_name VARCHAR2 ( 30


APP-FND-01564: ORACLE error 14097 in
exchange_and_drop_table (MSCSLD)

Cause:
exchange_and_drop_table (MSCSLD) failed due to ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
ORA-06512: at "SYSTEM.AD_DDL", line 188
ORA-06512: at line 1
.

The SQL statement being executed at the time of the error was: declare v_sql_stmt VARCHAR2 ( 4000 ) ; lv_partition_name VARCHAR2 ( 30 and was executed from the file .

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms