Error Message Received: ORA-20100 FND_FILE Fail (Doc ID 789364.1)

Last updated on AUGUST 12, 2017

Applies to:

Oracle Enterprise Asset Management - Version 11.5.10.2 and later
Oracle Work in Process - Version 11.5.10.0 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 08-May-2013***

Goal


After populating EAM Work Order header information, the following error message  is received.

Error:

Cannot create work order.

ORA-20100: File o0397099.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in the request log. in Package CST_EamJob_PUB Procedure Compute_Job_Estimate: l_stmt_num - 16
Error: CST_CST_EAMCOST_PUB.compute_job_estimate() in Package CSTPECEP Procedure
ESTIMATE_WORKORDER(40)


Similar error encountered in WIP Component Pick Release:

An unexpected error was encountered:
wip_picking_pvt.allocate: ORA-20100:
Error: FND_FILE failure.
Unable to create file, <file_name.tmp> in the dicrectory, /usr/tmp.
You will find more information in the request log..

Solution

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