ODS LOAD Failure With Error FDPSTP Failed Due To ORA-06510- Non Unique Index On Temp File Demands_ftl (Doc ID 2203100.1)

Last updated on MAY 03, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR

ODS LOAD failed

Log file shows

**SQL error and free**09-NOV-2016 17:04:35
ORACLE error 6510 in FDPSTP

Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 8014
ORA-06512: at line 1

The SQL statement being executed at the time of the error was: SELECT R.09-NOV-2016 17:04:35
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
09-NOV 17:04:35 : NONUNIQUE index creation on temporary table DEMANDS_FTL has completed with ERROR.

EXPECTED BEHAVIOR

Data Collection should complete without the reported error.

STEPS

The issue can be reproduced at will with the following steps:
1. Responsibility: Advanced Supply Chain Planner

2. Navigation: Collections > Oracle Systems > Standard Collections
3. Run data collection process

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.