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 JUNE 28, 2017

Applies to:

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

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

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.