My Oracle Support Banner

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:

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



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.


Data Collection should complete without the reported error.


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


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

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