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 laterInformation 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 |