MSCPLD - Loader Worker With Direct Load Option Errors APP-FND-01564: ORACLE Error 28665 (Doc ID 1583817.1)

Last updated on MAY 01, 2017

Applies to:

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

Goal

On 12.1.3 Memory Based Planner:

Users created a custom partitioned index on table MSC_DEMANDS (MSC_DEMANDS_N8_XXX) .  Whenever a new plan is created or existing plan is modified, compression is automatically getting enabled on some index partition's and resulting in the failure of the VCP plans.

Attaching the ddl of the index, Please help us in resolving this.

=============
SQL> select INDEX_OWNER,INDEX_NAME,PARTITION_NAME,STATUS,COMPRESSION from ALL_IND_PARTITIONS where COMPRESSION='ENABLED';

INDEX_OWNER INDEX_NAME PARTITION_NAME STATUS COMPRESS
------------------------------ ------------------------------ ------------------------------ -------- --------
MSC MSC_DEMANDS_N8_XXX DEMANDS_47027 USABLE ENABLED
MSC MSC_DEMANDS_N8_XXX DEMANDS_47028 USABLE ENABLED
MSC MSC_DEMANDS_N8_XXX DEMANDS_46027 USABLE ENABLED
MSC MSC_DEMANDS_N8_XXX DEMANDS_47029 USABLE ENABLED
=============

MSCPLD - Loader Worker With Direct Load Option errors with the following:


Error string=
Statement with the error:
declare v_sql_stmt VARCHAR2 ( 4000 ) ; lv_partition_name VARCHAR2 ( 30
 
 
APP-FND-01564: ORACLE error 28665 in
exchange_and_drop_table (MSCSLD)
 
Cause:
exchange_and_drop_table (MSCSLD) failed due to ORA-28665: table and partition must have same compression attribute
ORA-06512: at "SYSTEM.AD_DDL", line 165
ORA-06512: at line 1
=============

How was this resolved?
 

Solution

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