Error during Collections but the Request Log appears to be cut off ORA-06512 ORACLE error 6512 in FDPSTP

(Doc ID 1436439.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked for relevance on 12-Nov-2014 ***

Symptoms


On : 12.1.3 version, Data Collections

When attempting to run data collections the child request Generate Trading Partner Keys fails and generates the following error:

ERROR
-----------------------
MSCTPTK module: Generate Trading Partner Keys
+---------------------------------------------------------------------------+

Current system time is 27-FEB-2012 17:22:52

+---------------------------------------------------------------------------+

**Starts**27-FEB-2012 17:22:52
ORACLE error 6512 in FDPSTP

Cause: FDPSTP failed due to ORA-06512: at "APPS.MSC_CL_SETUP_ODS_LOAD", line 5095
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 6937
ORA-06512: at line 1
.

The SQL statement being executed at the time of the error was:  and wa
+---------------------------------------------------------------------------+

Note that this message itself did not tell us a lot of information and even setting MRP: Debug Mode = Yes did not help further debug the issue.  However, once we turned on then the new for R12  MSC:Coll Performance Debug Mode to High (Verbose) then we saw the additional message:

FDPSTP failed due to ORA-20100: Error: FND_FILE failure. Unable to create file, o0005156.tmp in the directory, /usr/tmp.

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