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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms