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 DECEMBER 10, 2018

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

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.