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.
On : 7.3.1 version, LoadData
When attempting to load data,
the following error occurs.
21-FEB-13 DATA_LOAD "-20003 ORA-20003: Error in PACKAGE BODY DATA_LOAD line 4765
When manually executing from back-end EP_LOAD_SALES procedure:
got the following error:
Error starting at line 1 in command:
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
*Action: DROP the specified index, or REBUILD the specified index, or
REBUILD the unusable index partition
The issue can be reproduced at will with the following steps:
1. run workflow to load data
The issue has the following business impact:
Due to this issue, users cannot data in production instance
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
|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.|