DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, July 17, 2017

ORA-20100: ORA-20100: File o2127370.tmp creation failed.

Concurrent request failed with the following error in log file.

Error
--------
ORA-20100: ORA-20100: File o2127370.tmp creation failed.
File could not be opened or operated on as requested.

Action: Make sure the directory - /usr/tmp - is a valid directory with write permissions and is accessible from the database server node for write operations. This d
ORA-20100: ORA-20100: File o2127370.tmp creation failed.
File could not be opened or operated on as requested.

Action: Make sure the directory - /usr/tmp - is a valid directory with write permissions and is accessible from the database server node for wr
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
p_event_class_rec.application_id201
p_event_class_rec.tax_event_type_codeCREATE
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...


Cause:
----------

   This issue usually occurs if you are using same UTL directory for more than one instance.if other instance is an clone of production than this issue occurs because of the tmp file of one instance will be same of other instance.


Solution:
----------


Step 1: Go to the UTL directory location,check for the tmp file with the tmp file in the log file.

Step 2 : If the file exists move that file or remove that file then rerun the request.


No comments: