My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.