REP-0118: Unable to create a temporary file

Almost the same problem i have found when execute query using form applet when i got this message FRM-41838: Unable to open temporary record buffer file %s.  And then i got this message when i run report. Here the message,

REP-0118 Unable to create a temporary file

The solution i found that maybe help for anyone who face the same problem,

– Check user variables
TEMP and TMP refers to directory that exists, if not exists then you must edit the value

– check free space on the disk, it must be enough space to create temporary file

– delete file in temporary directory, maybe, it cannot be modified because read only or already exists

– check registry setting using REGEDIT, locate variable REPORTS_TMP underkey hkey_local_machine/software/oracle/<oracle home>
make sure the value of the variable refers to exist directory

FRM-41838: Unable to open temporary record buffer file %s.

Today, I got this error message when execute query in form applet

FRM-41838 Unable to open temporary record buffer file
ORA-01403: no data found

The result of my search about this message explain this,

FRM-41838: Unable to open temporary record buffer file %s.
Cause : Unable to open file used as temporary record buffer.
Action: Verify that the file system or directory in which the file resides exists and that you have permissions to read and write to it.

The solution that maybe help,

The problem i found in opmn.xml.
So, search <variable id=”TMP” value=”C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1″/>
there is a reference to temp directory which doesn’t exists, edit the value to a valid directory.

[- -]