Epload Sales Failed To Run Successfully (Doc ID 1531855.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.1 and later
Information in this document applies to any platform.

Symptoms

On : 7.3.1 version, LoadData

When attempting to load data,
the following error occurs.

ERROR
-----------------------
21-FEB-13 DATA_LOAD "-20003 ORA-20003: Error in PACKAGE BODY DATA_LOAD line 4765
  executing ACTIVE_PROC_DYN('EP_LOAD_SALES')"

When manually executing from back-end EP_LOAD_SALES procedure:

exec EP_LOAD_SALES;

got the following error:

Error starting at line 1 in command:
begin
ep_load_sales;
end;
Error report:
ORA-01502: index 'DMN.SALES_DATA_PK' or partition of such index is in unusable state
ORA-06512: at "DMN.EP_LOAD_SALES", line 658
ORA-06512: at line 2
01502. 00000 -  "index '%s.%s' or partition of such index is in unusable state"
*Cause:    An attempt has been made to access an index or index partition
          that has been marked unusable by a direct load or by a DDL
          operation
*Action:   DROP the specified index, or REBUILD the specified index, or
          REBUILD the unusable index partition


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run workflow to load data

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot data in production instance

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