My Oracle Support Banner

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 AUGUST 17, 2023

Applies to:

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

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.

Changes

 

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
Changes
Cause
Solution
References


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