[Tip] Fnd_file Failure. Unable to Create File, O1983381.tmp

[dr_gori]

When performing a competitor, I received the following message in a newly cloned environment:

Select all

Unexpected error happened on GENERATE_RECONCIL_REPORT_P ORA-20100: Error: FND_FILE failure. Unable to create file, o1983381.tmp in the directory, /db/gebs/nofa/app6/comn/R12/temp. 
You will find more information in the request log. - ORA-06512: at "APPS.FND_FILE", line 417 
ORA-06512: at "APPS.FND_FILE", line 526 
ORA-06512: at "APPS.XXPA2871_PKGA", line 922

Solution:
There was a directory Wrong in the environment variable: (it was pointing to a non-existent folder)

Select all

echo $APPLPTMP

After correcting this, Chmod was missing in the folder. (He was without writing permissions).

After correcting this, we find that the Oracle UTL_FILE_DIR parameter was also wrong:

Select all

 select * from v$parameter 
 where name='utl_file_dir'

In summary: Somebody faltered at the time of doing the clone
Stay here as registration ...